以下是与角色、用户以及系统、角色、对象相关权限字典。
----权限相关字典:
--- 查看角色的字典:
Select * from dba_roles;
---查看用户的字典:
select * from dba_users;
select * from all_users;
select * from user_users;
---查看用户或角色系统权限的字典:
select * from dba_sys_privs;
select * from user_sys_privs;
select * from role_sys_privs;
---查看用户或角色所拥有的角色:
select * from dba_role_privs;
select * from user_role_privs;
select * from role_role_privs;
---查看用户对象权限字典:
select * from dba_tab_privs;
select * from all_tab_privs;
select * from user_tab_privs;
select * from role_tab_privs;
---拓展相关权限:
Select * from USER_TAB_PRIVS_MADE
用户对象上赋权者与被赋权者的历史赋权情况
Select * from USER_TAB_PRIVS_RECD
用户对象上拥有者与被赋予者的历史赋权情况
Select * from USER_COL_PRIVS_MADE
用户对象列上赋权者与被赋者的历史赋权情况
Select * from USER_COL_PRIVS_RECD
用户对象列上拥有者与被赋者的历史赋权情况
--权限相关所有字典:
TABLE_NAME | COMMENTS | |
1 | DBA_AQ_AGENT_PRIVS | |
2 | DBA_COL_PRIVS | All grants on columns in the database |
3 | DBA_ROLE_PRIVS | Roles granted to users and roles |
4 | DBA_RSRC_CONSUMER_GROUP_PRIVS | Switch privileges for consumer groups |
5 | DBA_RSRC_MANAGER_SYSTEM_PRIVS | system privileges for the resource manager |
6 | DBA_SYS_PRIVS | System privileges granted to users and roles |
7 | DBA_TAB_PRIVS | All grants on objects in the database |
8 | USER_AQ_AGENT_PRIVS | |
9 | USER_COL_PRIVS | Grants on columns for which the user is the owner, grantor or grantee |
10 | USER_COL_PRIVS_MADE | All grants on columns of objects owned by the user |
11 | USER_COL_PRIVS_RECD | Grants on columns for which the user is the grantee |
12 | USER_ROLE_PRIVS | Roles granted to current user |
13 | USER_RSRC_CONSUMER_GROUP_PRIVS | Switch privileges for consumer groups for the user |
14 | USER_RSRC_MANAGER_SYSTEM_PRIVS | system privileges for the resource manager for the user |
15 | USER_SYS_PRIVS | System privileges granted to current user |
16 | USER_TAB_PRIVS | Grants on objects for which the user is the owner, grantor or grantee |
17 | USER_TAB_PRIVS_MADE | All grants on objects owned by the user |
18 | USER_TAB_PRIVS_RECD | Grants on objects for which the user is the grantee |
19 | ALL_COL_PRIVS | Grants on columns for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
20 | ALL_COL_PRIVS_MADE | Grants on columns for which the user is owner or grantor |
21 | ALL_COL_PRIVS_RECD | Grants on columns for which the user, PUBLIC or enabled role is the grantee |
22 | ALL_TAB_PRIVS | Grants on objects for which the user is the grantor, grantee, owner, or an enabled role or PUBLIC is the grantee |
23 | ALL_TAB_PRIVS_MADE | User's grants and grants on user's objects |
24 | ALL_TAB_PRIVS_RECD | Grants on objects for which the user, PUBLIC or enabled role is the grantee |
25 | ROLE_ROLE_PRIVS | Roles which are granted to roles |
26 | ROLE_SYS_PRIVS | System privileges granted to roles |
27 | ROLE_TAB_PRIVS | Table privileges granted to roles |
28 | SESSION_PRIVS | Privileges which the user currently has set |
29 | V$ENABLEDPRIVS | Synonym for V_$ENABLEDPRIVS |
30 | GV$ENABLEDPRIVS | Synonym for GV_$ENABLEDPRIVS |
---系统权限导图字典:
sys@PROD>select name from sys.system_privilege_map
2 order by name;
NAME
-----------------------------------
ADMINISTER ANY SQL TUNING SET
ADMINISTER DATABASE TRIGGER
... ...
NAME
-----------------------------------
CREATE LIBRARY
CREATE MATERIALIZED VIEW
CREATE MEASURE FOLDER
CREATE MINING MODEL
CREATE OPERATOR
CREATE PROCEDURE
CREATE PROFILE
CREATE PUBLIC DATABASE LINK
CREATE PUBLIC SYNONYM
CREATE ROLE
CREATE ROLLBACK SEGMENT
... ...
SELECT ANY CUBE
SELECT ANY CUBE DIMENSION
SELECT ANY DICTIONARY
SELECT ANY MINING MODEL
SELECT ANY SEQUENCE
SELECT ANY TABLE
NAME
-----------------------------------
SELECT ANY TRANSACTION
SYSDBA
SYSOPER
UNDER ANY TABLE
UNDER ANY TYPE
UNDER ANY VIEW
UNLIMITED TABLESPACE
UPDATE ANY CUBE
UPDATE ANY CUBE BUILD PROCESS
UPDATE ANY CUBE DIMENSION
UPDATE ANY TABLE
209 rows selected.
#共有200多条相关授予权限的导图。
--例如将查看数据库所有字典授予给某个用户:
GRANT SELECT ANY DICTIONARY to SUSKY;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31392094/viewspace-2131016/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31392094/viewspace-2131016/