Oracle PL/SQL for DBAs

Name

DBA_POLICIES

Synopsis

This view shows all the RLS policies on the database, whether they are enabled or not.

		Oracle Database version
Column name	Description	9i	10g
OBJECT_OWNER	Owner of the table on which the policy is defined.	Yes	Yes
OBJECT_NAME	Name of the table on which the policy is defined.	Yes	Yes
POLICY_GROUP	If this is part of a group, the name of the policy group.	Yes	Yes
POLICY_NAME	Name of the policy.	Yes	Yes
PF_OWNER	Owner of the policy function, which creates and returns the predicate.	Yes	Yes
PACKAGE	If the policy function is a packaged one, this is the name of the package.	Yes	Yes
FUNCTION	Name of the policy function.	Yes	Yes
SEL	Indicates that this is a policy for SELECT statements on this table.	Yes	Yes
INS	Indicates that this is a policy for INSERT statements on this table.	Yes	Yes
UPD	Indicates that this is a policy for UPDATE statements on this table.	Yes	Yes
DEL	Indicates that this is a policy for DELETE statements on this table.	Yes	Yes
IDX	Indicates that this is a policy for CREATE INDEX statements on this table (only for Oracle Database 10g Release 2).	No	Yes
CHK_OPTION	Indicates whether the update check option was enabled when the policy was created.	Yes	Yes
ENABLE	Indicates whether the policy is enabled.	Yes	Yes
STATIC_POLICY	Indicates whether this is a static policy.	Yes	Yes
POLICY_TYPE	Dynamism of the policy (e.g., STATIC). See ADD_POLICY for a complete list.	No	Yes
LONG_PREDICATE ...