Skip to main content

Is there a way to see what users are granted system privileges?  I know I can look at each individual permission set and see if any system privileges are assigned, but that is very time consuming.

SELECT * FROM DBA_SYS_PRIVS;
 

If we are looking for IFS system privileges not Oracle system then following query is helpful:

select * from SYSTEM_PRIVILEGE_GRANT_TAB

 

Hi @TosohLBlum 

the easiest way to find it out is with rmt on system privileges.

You can show a list.

 

Reply


Terms & ConditionsCookie settings