Seven methods for viewing Oracle user permissions

 

To view the permissions of an Oracle user, you must first traverse all the users and then view the permissions of the Oracle user. I hope this article will help you.

 

 

 

1. View All Users:

 

 

 

Select * from dba_users; select * from all_users; select * from user_users;

 

 

 

2. view system permissions of users or roles (system permissions assigned to users or roles ):

 

 

 

Select * from dba_sys_privs; select * from user_sys_privs;

 

 

 

3. view the permissions contained in a role (only roles owned by login users can be viewed)

 

 

 

SQL> select * from role_sys_privs;

 

 

 

4. View user object permissions:

 

 

 

Select * from dba_tab_privs; select * from all_tab_privs; select * from user_tab_privs;

 

 

 

5. view all roles:

 

 

 

Select * from dba_roles;

 

 

 

6. view the roles owned by a user or role:

 

 

 

Select * from dba_role_privs; select * from user_role_privs;

 

 

 

7. Check which users have sysdba or sysoper system permissions (the corresponding permissions are required for query)

 

 

 

Select * from V $ PWFILE_USERS