Oracle in a Nutshell

Calls

PROCEDURE DBMS_RLS.ADD_POLICY (object_schema IN VARCHAR2 DEFAULT NULL, object_name IN VARCHAR2, policy_name IN VARCHAR2, function_schema IN VARCHAR2 DEFAULT NULL, policy_function IN DEFAULT VARCHAR2, statement_types IN VARCHAR2 DEFAULT NULL, update_check IN BOOLEAN DEFAULT FALSE, enable IN BOOLEAN DEFAULT TRUE [,static_policy IN BOOLEAN DEFAULT FALSE]#);

Adds policy_name to object_schema.object_name. The policy uses function_schema.policy_schema and applies to statement_types, which can include any combination of SELECT, INSERT, UPDATE, and DELETE. If update_check, the server checks the policy against the value after an INSERT or UPDATE. If static_policy (new with Oracle9i), the server assumes that the policy produces the same predicate for all users except SYS or any user with EXEMPT ACCESS POLICY privilege.

PROCEDURE DBMS_RLS.DROP_POLICY (object_schema IN VARCHAR2 DEFAULT NULL, object_name IN VARCHAR2, policy_name IN VARCHAR2);

Drops policy_name for object_schema.object_name.

PROCEDURE DBMS_RLS.REFRESH_POLICY (object_schema IN VARCHAR2 DEFAULT NULL, object_name IN VARCHAR2, policy_name IN VARCHAR2);

Forces all cached statements associated with object_schema.object_name to be reparsed.

PROCEDURE DBMS_RLS.ENABLE_POLICY (object_schema IN VARCHAR2 := NULL, object_name IN VARCHAR2, policy_name IN VARCHAR2, enable IN BOOLEAN);

Enables (if enable is TRUE) or disables (if enable is FALSE) policy_name for object_schema.object_name.

PROCEDURE DBMS_RLS.CREATE_POLICY_GROUP (object_schema ...