The types of data dictionary views are:user,all and  DBA, respectively. User_*: Information about the object that the user owns, that is, the object information that the user has created all_*: information about the objects that the user can access, information about the objects that the user creates themselves, and the information that is created by the other user dba_*: Information about the objects in the entire database ( Here the * can be tables,indexes,objects,users and so on. ) 1. View All Users select * from dba_user; select * from all_users; select * from user_users; 2. View User system Permissions select * from dba_sys_privs; select * from all_sys_privs; select * from user_sys_privs; 3. View User Object Permissions select * from dba_tab_privs; select * from all_tab_privs; select * from user_tab_privs; 4. View all characters select * from dba_roles; 5. View the roles owned by the user select * from dba_role_privs; select * from user_role_privs; 6. View the default tablespace for the current user select username,default_tablespace from user_users; 7. View specific permissions for a role such as Grant connect,resource,create session,create view to tesT 8, view RESOURCE with those permissions with select * from dba_sys_privs where grantee= ' RESOURCE '
How to query user permissions in Oracle