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
Userlevel 7
+22
Hi
the easiest way to find it out is with rmt on system privileges.
You can show a list.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.