Data dictionary tables for Oracle users, roles, permissions (System permissions, object permissions)

1? Dictionary Table of the three

1.1? User

Select? *? From? dba_users;

Select? *? From? all_users;

Select? *? From? user_users;

1.2? role

Select? *? From? dba_roles;

1.3? Permissions

Divided into system permissions and object permissions:

Select? *? From? system_privilege_map;

Select? *? From? table_privilege_map;

2? A dictionary table of the relationships between three people

The table name suffix for this type of relational dictionary table contains "_privs"

2.1? Users and Roles

User-owned roles:

Select? *? From? dba_role_privs;

Select? *? From? user_role_privs;

Select? *? From? role_role_privs;

r Ole_role_privs and role_role_ Privs? dba_role_privs

d Ba_role_privs grantee fields include user name and role name

u Ser_role_privs username fields include user name of the operating user

Role_role_privs of the The role field is just a character name .

Note:? role_all_privs, huh? Why didn't you understand ? .

2.2? Users and Permissions

User-owned system permissions:

Select? *? From? dba_sys_privs;

Select? *? From? user_sys_privs;

Note:? all_sys_privs, huh? Why didn't you understand ? .

??

User-owned object permissions:

Select? *? From? dba_tab_privs;

Select? *? From? all_tab_privs;

Select? *? From? user_tab_privs;

Select? *? From? dba_col_privs;

Select? *? From? all_col_privs;

Select? *? From? user_col_privs;

2.3? Roles and Permissions

Query granted object permissions (usually owned by the owner)

Select? *? From? role_sys_privs;

Select? *? From? role_tab_privs;

3? other

Query granted object permissions (usually owned by the owner)

Select? *? From? user_tab_privs_made;

Select? *? From? all_tab_privs_made;

User-owned object permissions

Select? *? From? user_tab_privs_recd;

Select? *? From? all_tab_privs_recd;

Object permissions for user-assigned columns

Select? *? From? user_col_privs_made;

Select? *? From? all_col_privs_made;

User-owned object permissions on the column

Select? *? From? user_col_privs_recd;

Select? *? From? all_col_privs_recd;

?

Transferred from: http://blog.csdn.net/huang_xw/article/details/6527762

Data dictionary tables for Oracle users, roles, permissions (System permissions, object permissions)