oracle user sql
依據權限定義,受與使用者權限的結果如下
SELECT username,
granted_role,
admin_option,
default_role,
os_granted
FROM user_role_privs;
SELECT username,
PRIVILEGE,
admin_option
FROM user_sys_privs;
SELECT grantee,
owner,
table_name,
grantor
-- priviege
-- granttable
-- HIERARCHY
FROM user_tab_privs;