Oracle 视图 ALL_POLICY_GROUPS 官方解释,作用,如何使用详细说明
本站中文解释
ALL_POLICY_GROUPS视图提供了有关数据库行政策组的信息,行政策组是Oracle Database Vault中控制领域用户访问数据库资源行为的一种方法。
使用方法:
查询所有行政策组:
SELECT * FROM ALL_POLICY_GROUPS;
查询指定名称的行政策:
SELECT * FROM ALL_POLICY_GROUPS WHERE group_name = ‘XYZ’;
官方英文解释
ALL_POLICY_GROUPS describes the policy groups defined for the synonyms, tables, and views accessible to the current user.               
Related Views
- DBA_POLICY_GROUPSdescribes all policy groups in the database.
- USER_POLICY_GROUPSdescribes the policy groups defined for the synonyms, tables, and views owned by the current user. This view does not display the- OBJECT_OWNERcolumn.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
| 
 | 
 | Owner of the synonym, table, or view | |
| 
 | 
 | Name of the synonym, table, or view | |
| 
 | 
 | Name of the policy group | |
| 
 | 
 | Indicates whether the policy group is applied and enforced in all application PDBs ( | |
| 
 | 
 | Indicates whether the policy group is inherited from the root ( | 
See Also:
- “DBA_POLICY_GROUPS” 
- “USER_POLICY_GROUPS” 
编辑:568数据
标签:行政,数据库,英文,视图,中文
