Oracle Learning (18) Summary of views of user, role, and permission information

Oracle has a number of views built into the SYS user scenario that we can use to easily view system-related information. We can call these views without schema, and here are some

Summary of views about user, role, and permission information:

(1) all_users view: You can view all users that the current user can see

(2) Dba_users view: You can view all the user information in the database

(3) User_users view: Can view the current user's user information

(4) Dba_ts_quotas view: You can view the user's table space limit

(5) User_password_limits view: You can view the password profile parameters for the current user

(6) User_resource_limits view: You can view resource limits for the current user

(7) V$session View: View session information for each current session

(8) V$sesstat view: View statistics for user sessions

(9) Dba_roles view: You can view all the roles that exist in the current database

(Ten) Session_roles view: You can view the roles enabled by the current user

(one) Dba_role_privs view: You can view the grant relationships between all users and roles or roles and roles in a database

() User_role_privs View: You can view the permissions of the current user

(Dba_sys_privs view: You can view system permissions granted to all users or roles

(user_sys_privs) View: You can view the system permissions that the current user is granted

(session_privs) View: You can view system permissions enabled by the current user

All_col_privs View: You can view the authorization of all Column objects for the current user or the public user group that is the owner, the grantee, or the grantee's user, and the Column object is the field in the table

(dba_col_privs) View: You can view authorization for all Column objects in a database

(User_col_privs view: Authorization to view all column objects of the current user or its owner, grantor, or grantee

(Dba_tab_privs view: You can view permissions for all objects in a database

All_tab_privs View: You can view the authorization of a user or an object that is public as its grantor

User_tab_privs View: Authorization to view all objects for which the current user is the grantee

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/