Oracle 视图 DBA_UNUSED_GRANTS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_UNUSED_GRANTS提供了系统中未使用的权限列表，用于识别在用户中未使用且没有被移除掉的系统权限，以帮助发掘重复或过时的权限，并从而改善权限管理。
要使用这个视图，你可以使用下面的SQL语句来获取系统内未使用的权限:
SELECT * FROM DBA_UNUSED_GRANTS;
官方英文解释
DBA_UNUSED_GRANTS shows all the grants that are not used during the privilege capture.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the privilege analysis policy |
|
|
|
|
Name of the run of the privilege analysis policy |
|
|
|
|
Name of the user who is granted with the privilege or role |
|
|
|
|
Name of the role that is granted to the grantee |
|
|
|
|
Name of the system privilege that is granted to the grantee |
|
|
|
|
Name of the object privilege that is granted to the grantee |
|
|
|
|
Name of the user privilege that is granted to the grantee |
|
|
|
|
Name of the owner of the object for which the object privilege is granted |
|
|
|
|
Name of the object for which the object privilege is granted |
|
|
|
|
Type of the object for which the object privilege is granted |
|
|
|
|
Name of the column in the table for which the object privilege is granted |
|
|
|
|
Whether the grant option of the privilege is granted |
See Also:
Oracle Database Security
Guide for more information about privilege analysis
