Monday 6 July 2015

How to check current user privileges or permissions for a specific user in Oracle

select * from SDE_ROLE_PRIVS where username ='DATA01';
select * from SDE_TAB_PRIVS where Grantee = 'DATA01';
select * from SDE_SYS_PRIVS where username = 'DATA01';

 OR

select privilege
from dba_sys_privs
where grantee='SDE'
order by 1;

 OR

select privilege
from dba_sys_privs
where grantee='DATA01'
order by 1;



OR

set heading off
set pages 0
set long 9999999
select dbms_metadata.get_granted_ddl('ROLE_GRANT', 'SDE') 
from dual;
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', 'SDE') 
from dual;
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', 'SDE') 
from dual;



No comments:

Post a Comment