December 2002
Intermediate to advanced
928 pages
85h 29m
English
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 ...