Oracle data dictionary and dynamic performance views

Data dictionaries and dynamic performance views
Data dictionary is an important part of Oracle database, which improves some system information of database. (Static information)
The dynamic performance view records the information after the routine is started. (Dynamic information)

The data dictionary records the system Information of the data, is a collection of read-only tables and dynamic views, the owner of the data dictionary is the SYS user, and the user can only execute on the data dictionary
Query operations, whose maintenance and modifications are automatically completed by the system. (Can touch not move)

Typical applications for data dictionaries:
Select table_name from user_tables;//view the name of the table created by the current user
Select table_name from all_tables;//displays the tables in the database to which the current user can access
Select table_name from dba_tables;//the user executing this command must have DBA authority or the system permissions of select any table

Oracle will store the user's information in the database:
Select username from dba_users;//Show All users
Select password from dba_users;//display password

Dba_sys_privs can display the system permissions that the user has
Dba_tab_privs can display object permissions for a user
Dba_col_privs can display the column permissions that the user has
Dba_role_privs can show the role that the user has

Permissions are divided into system permissions and object permissions, and the set of permissions becomes a role.
The role of the Oracle system:
SELECT * from Dba_roles;

How many system permissions Oracle has:
SELECT * from System_prvilege_map order by name;

How many object permissions Oracle has:
Select distinct privilege from Dba_tab_privs;

How to query the permissions that a role includes: (Take connet role as an example)
How many system permissions a role contains:
SELECT * from Dba_sys_privs where grantee= ' CONNECT ';
Or
SELECT * from Role_sys_privs where role= ' CONNECT ';
How many object permissions a role contains:
SELECT * from Dba_tab_privs where grantee= ' CONNECT ';

How to see which roles a user contains:
SELECT * from Dba_role_privs where grantee= ' CONNECT ';

SELECT * from global_name;//displays the full name of the current database

The dynamic performance view is used to record the activity information of the current routine, with fewer actual applications

Oracle data dictionary and dynamic performance views