Tuesday, May 21, 2013

Oracle DB: Am I a SYSDBA?

given the user INSTALL, here are all the SQL you can try to check if you are a SYSDBA:

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: