权限查询

col PRIVILEGE for a30
col GRANTOR for a30
col TABLE_NAME for a30
select PRIVILEGE from  dba_sys_privs where  grantee='ZCBUS';
select granted_role from dba_role_privs where  grantee='ZCBUS';
select PRIVILEGE,GRANTOR,TABLE_NAME from dba_tab_privs where  grantee='ZCBUS';

注：12C以上版本数据库的CDB模式zcbus用户名要以c##开头

LOGMNR权限查询返回结果（以ZC_TEST用户weili）：