eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.QUEUE_PRIVILEGES

Object Details

Object Name:	QUEUE_PRIVILEGES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Grants on queues for which the user is the grantor, grantee, owner,
or an enabled role or PUBLIC is the grantee

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
GRANTEE	VARCHAR2	(128)	Yes	Name of the user to whom access was granted
OWNER	VARCHAR2	(128)	Yes	Owner of the object
NAME	VARCHAR2	(128)	Yes	Name of the object
GRANTOR	VARCHAR2	(128)	Yes	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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT GRANTEE
,      OWNER
,      NAME
,      GRANTOR
,      ENQUEUE_PRIVILEGE
,      DEQUEUE_PRIVILEGE
FROM SYS.QUEUE_PRIVILEGES;

Dependencies

[top of page]

SYS.QUEUE_PRIVILEGES references the following:

SYS: OBJ$; OBJAUTH$; USER$

SYS.QUEUE_PRIVILEGES is referenced by following:

PUBLIC: QUEUE_PRIVILEGES