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:


No comments: