select * from session_privs;
select * from user_sys_privs;
select * from dba_role_privs where GRANTEE = 'INSTALL';
select * from dba_sys_privs where GRANTEE = 'INSTALL';
select * from dba_tab_privs where GRANTEE = 'INSTALL';
select dbms_metadata.get_granted_ddl('ROLE_GRANT', 'INSTALL') from dual;
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', 'INSTALL') from dual;
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', 'INSTALL') from dual;
In my case, the result of "select * from dba_role_privs where GRANTEE = 'INSTALL';" is:
"GRANTEE" "GRANTED_ROLE" "ADMIN_OPTION" "DEFAULT_ROLE" "INSTALL" "CONNECT" "NO" "YES" "INSTALL" "ROLE_DBA_ADMIN" "NO" "YES"
No comments:
Post a Comment