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;
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