SELECT grantee, granted_role FROM dba_role_privs WHERE grantee = :user
SELECT grantee, privilege FROM dba_sys_privs WHERE grantee = :user
SELECT grantee, privilege FROM dba_sys_privs WHERE grantee = :user
得到非queue的tables
SELECT OBJECT_NAME
FROM dba_objects
where owner = :owner1
AND OBJECT_TYPE = 'TABLE'
AND object_name not in (SELECT t.queue_table
FROM dba_queue_tables t
WHERE t.owner = :owner2)
AND object_name not like 'SYS%'
AND object_name not like 'AQ$%'
311