Oracle 视图 DBA_CHECKED_ROLES_PATH 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_CHECKED_ROLES_PATH可以显示当前用户拥有的当前有效角色路径，包括其有效角色的组成称号以及其获取方式。查询此视图可以跟踪用户角色的任意连接和分配模式，无论是调用Oracle SYSTEM_ROLES系统视图来查看有效的ROLE_ID还是调用角色的父角色的可用角色，都可以显示在视图中，以帮助开发和管理员使用跟踪角色授予其他角色的过程，以便更好地管理用户安全。
要使用Oracle DBA_CHECKED_ROLES_PATH视图，可以使用以下SQL语句：
SELECT * FROM DBA_CHECKED_ROLES_PATH;
官方英文解释
DBA_CHECKED_ROLES_PATH lists the roles that are used for the role analysis policies reported by the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure.
This view provides access to analyzed role records in SYS tables.
You must have the CAPTURE_ADMIN role to access this view.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Name of a role analysis policy |
|
|
|
|
The sequence number of the role analysis run during which the role was reported |
|
|
|
Operating system login username |
|
|
|
|
Client host machine name |
|
|
|
|
Module name |
|
|
|
|
|
Name of the user whose role was reported |
|
|
|
Checked role |
|
|
|
|
Role grant paths |
|
|
|
|
The name of the run during which the role was reported |
See Also:
“DBA_CHECKED_ROLES”
