国外主机测评 - 国外VPS，国外服务器，国外云服务器，测评及优惠码本站中文解释
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 |
|---|---|---|---|
|
|
|
|
Name of the user or role to whom access was granted |
|
|
|
|
Owner of the object |
|
|
|
|
Name of the object |
|
|
|
|
Name of the user who performed the grant |
|
|
|
Permission to |
|
|
|
|
Permission to |
