We have created an user with the following privilegs in oracle:
CREATE ANY PROCEDURE
CREATE ANY TRIGGER
CREATE ANY TYPE
CREATE ANY VIEW
CREATE SESSION
CREATE TABLE
SELECT ANY SEQUENCE
SELECT ANY TABLE
If this user makes a "select * from a queue table" in the pl/sql Developer an access violation occurs. The select statement works for all other users.
Thank you for help
CREATE ANY PROCEDURE
CREATE ANY TRIGGER
CREATE ANY TYPE
CREATE ANY VIEW
CREATE SESSION
CREATE TABLE
SELECT ANY SEQUENCE
SELECT ANY TABLE
If this user makes a "select * from a queue table" in the pl/sql Developer an access violation occurs. The select statement works for all other users.
Thank you for help
