Description of Oracle Data Dictionary attempts

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, information about the objects created by users plus

Information about objects created by other users but accessed by the user

DBA _ *: 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;

2. view the user's 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 User Roles

Select * From dba_role_privs;

Select * From user_role_privs;

6. view the default tablespace of the current user

Select username, default_tablespace from user_users;

7. view the specific permissions of a role

Such as grant connect, resource, create session, create view to test;

8. view the permissions of a resource.

Use select * From dba_sys_privs where grantee = 'resource ';