Oracle教程 2023-03-22

Oracle 视图 QUEUE_PRIVILEGES 官方解释，作用，如何使用详细说明

Oracle 视图(QUEUE_PRIVILEGES) 它用于存储用户权限和访问数据队列的信息。

使用这个视图，可以查询某个数据队列的权限情况，也可以查询某个用户的sh数据队列访问权限。

可以使用下面的SQL语句匹配队列和用户之间的权限：

SELECT * FROM ALL_QUEUE_PRIVILEGES
WHERE GRANTEE = ‘USER_NAME’
AND QUEUE_NAME = ‘QUEUE_NAME’;

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

Column	Datatype	NULL	Description
`GRANTEE`	`VARCHAR2(128)`	`NOT NULL`	Name of the user or role to whom access was granted
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the object
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the object
`GRANTOR`	`VARCHAR2(128)`	`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

分享到：