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”


数据运维技术 » Oracle 视图 DBA_POLICIES 官方解释,作用,如何使用详细说明