View user permissions in Oracle

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

 

Note:

1. Run the following statement to view the system permissions provided by Oracle:

Select name from SYS. system_privilege_map

 

2. View All system permissions of a user (including the system permissions of the role)

Select privilege from dba_sys_privs where grantee = 'datauser'
Union
Select privilege from dba_sys_privs where grantee in (select granted_role from dba_role_privs where grantee = 'datauser ');