QUEUE_PRIVILEGES

QUEUE_PRIVILEGES shows all Advanced Queuing object privileges granted to the session.

Column	Datatype	NULL	Description
GRANTEE	VARCHAR2(30)	NOT NULL	Name of the user to whom access was granted
OWNER	VARCHAR2(30)	NOT NULL	Owner of the object
NAME	VARCHAR2(30)	NOT NULL	Name of the object
GRANTOR	VARCHAR2(30)	NOT NULL	Name of the user who performed the grant
ENQUEUE_PRIVILEGE	NUMBER		Permission to ENQUEUE to the queue
DEQUEUE_PRIVILEGE	NUMBER		Permission to DEQUEUE from the queue

Note:

1.

select * from QUEUE_PRIVILEGES;

GRANTEE	OWNER	NAME	GRANTOR	ENQUEUE_ PRIVILEGE	DEQUEUE_ PRIVILEGE
PUBLIC	SYS	SRVQUEUE	SYS	0	1
PUBLIC	SYS	SCHEDULER$_EVENT_QUEUE	SYS	0	1

Oracle data dictionary views

Oracle dynamic performance views