set verify off
set linesize 131
col grantee for a15
col privilege for a30
col column_name for a15
col owner for a20
col table_name for a30
SELECT 'ROLE' TYPE,
grantee,
granted_role privilege,
admin_option ad,
'/' table_name,
'/' column_name,
'/' owner
FROM dba_role_privs
WHERE grantee = UPPER ('&1')
UNION
SELECT 'SYSTEM' TYPE,
grantee,
privilege privilege,
admin_option ad,
'/' table_name,
'/' column_name,
'/' owner
FROM dba_sys_privs
WHERE grantee = UPPER ('&1')
UNION
SELECT 'TABLE' TYPE,
grantee,
privilege privilege,
grantable ad,
table_name,
'/' column_name,
owner
FROM dba_tab_privs
WHERE grantee = UPPER ('&1')
UNION
SELECT 'COLUMN' TYPE,
grantee,
privilege privilege,
grantable ad,
table_name,
column_name,
owner
FROM dba_col_privs
WHERE grantee = UPPER ('&1')
ORDER BY 1
/
undefine 1
set verify on
验证一下
读取flysync用户的权限
@/install/privs.sql flysync
结果：
TYPE GRANTEE PRIVILEGE AD TABLE_NAME COLUMN_NAME OWNER
------ --------------- ------------------------------ --- ------------------------------ --------------- --------------------
ROLE FLYSYNC CONNECT NO / / /
ROLE FLYSYNC EXECUTE_CATALOG_ROLE NO / / /
SYSTEM FLYSYNC CREATE SESSION NO / / /
SYSTEM FLYSYNC CREATE TABLE NO / / /
SYSTEM FLYSYNC SELECT ANY DICTIONARY NO / / /
SYSTEM FLYSYNC SELECT ANY TABLE NO / / /
SYSTEM FLYSYNC SELECT ANY TRANSACTION NO / / /
SYSTEM FLYSYNC UNLIMITED TABLESPACE NO / / /
TABLE FLYSYNC SELECT NO V_$PARAMETER / SYS