Oracle 视图 DBA_CHECKED_ROLES 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图 DBA_CHECKED_ROLES 是 Oracle 的数据字典视图,显示创建时间、角色名称以及该角色的属性的分析。它的用途是查看系统内部什么角色已经被检查使用,以及哪些角色正在被激活使用。
要使用这个视图,用户需要具有SELECT_CATALOG_ROLE 或者 SELECT ANY_DICTIONARY 的权限,而且只有DBA可以正常使用这个视图。
可以使用下列SQL语句查询 DBA_CHECKED_ROLES 视图中数据:
select * from dba_checked_roles;
查询后,将显示角色创建时间、角色名称以及该角色的属性等信息。
官方英文解释
DBA_CHECKED_ROLES
lists the roles (without role grant paths) that are used for the role analysis policies reported by the DBMS__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 |
|
|
|
The name of the run during which the role was reported |
See Also:
“DBA_CHECKED_ROLES_PATH”