Oracle 视图 DBA_USED_PRIVS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_USED_PRIVS用于查看当前系统中的用户已经使用的权限。它显示了从SYS或PUBLIC视图角度看到的用户的凭据和超权。此视图可以用于查找系统使用的某种特定访问功能,以及帮助定位权限的问题的来源。
使用DBA_USED_PRIVS视图的方法:
1. 打开SQL*Plus,连接到数据库。
2. 登录一个特殊用户,例如SYSDBA,并执行以下SQL:
SELECT GRANTEE, GRANTED_ROLE, ADMIN_OPTION, COMMON, AU_NAME
FROM DBA_USED_PRIVS;
3. 上面的查询将打印出当前系统中所有用户已经使用的权限,包括角色、临时角色、公共角色、管理选项等。
官方英文解释
DBA_USED_PRIVS
lists the privileges that are used for the privilege analysis policies reported by the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT
procedure.
This view provides access to analyzed privilege records in SYS
tables.
You must have the CAPTURE_ADMIN
role to access this view.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
| Name of a privilege analysis policy |
|
|
| The sequence number of the privilege analysis run during which the privilege was reported |
|
| Operating system login username | |
|
| Client host machine name | |
|
| Module name | |
|
|
| Name of the user whose privilege was reported |
|
| Used role | |
|
| Used system privilege | |
|
| Used object privilege | |
|
| Used user privilege | |
|
| Object owner | |
|
| Name of the object or user that | |
|
| Type of the object or user that | |
|
| Name of the column that | |
|
| Indicates whether the
| |
|
| Used privilege grant paths | |
|
| The name of the run during which the privilege was reported |
See Also:
“DBA_UNUSED_PRIVS”
Oracle Database Security
Guide for more information about privilege analysisOracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT
procedure