Oracle 视图 DBA_POLICIES 官方解释,作用,如何使用详细说明
本站中文解释
Oracle 视图 DBA_POLICIES 是DBA定义的所有策略的汇总集、概览,它们对对象(如用户和表)中的行和列执行限制或动作,比如可以触发警告、锁定数据和限制权限。使用DBA_POLICIES视图,DBA可以检查某个对象上设定了哪些策略,例如:
SELECT POLICY_NAME, POLICY_TYPE, OBJECT_SCHEMA,
OBJECT_NAME, ENABLED FROM DBA_POLICIES
WHERE OBJECT_SCHEMA=’SCOTT’ AND OBJECT_NAME=’EMPLOYEES’;
官方英文解释
DBA_POLICIES
describes all Oracle Virtual Private Database (VPD) security policies in the database. Its columns are the same as those in ALL_POLICIES
.
A security policy is a list of security requirements and rules that regulate row level access to database objects.
See Also:
“ALL_POLICIES”