How to view oracle user permissions

How to view the permissions of oracle users the types of ORACLE Data Dictionary views are: USER, ALL, and DBA.
USER _ *: Information about objects owned by users, that is, information about objects created by users ALL _ *: Information about objects accessible to users, that is, the information of the object created by the user plus the object created by other users, but the information DBA _ * that the user has the right to access: Information about objects in the entire database (here * Can be TABLES, INDEXES, OBJECTS, and USERS .) 1. View All users select * from dba_user; select * from all_users; select * from user_users; www.2cto.com 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 roles select * from dba_roles; 5. view the user's role select * from dba_role_privs; select * from user_role_privs; www.2cto.com 6. view the current user's default tablespace select username, default_tablespace from user_users; 7. view the specific permissions of a role, such as grant connect, resource, create session, and create view to TEST; 8. view the permissions of a RESOURCE using SELECT * FROM DBA_SYS_PRIVS where grantee = 'resource'; Author: jianhuili