December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_FGA.ADD_POLICY
(object_schema IN VARCHAR2,
object_name IN VARCHAR2,
policy_name IN VARCHAR2,
audit_condition IN VARCHAR2,
audit_column IN VARCHAR2,
handler_schema IN VARCHAR2,
handler_module IN VARCHAR2,
enable BOOLEAN);
Assigns audit policy_name and handler_module to object_name in object_schema.
PROCEDURE DBMS_FGA.DROP_POLICY
(object_schema IN VARCHAR2,
object_name IN VARCHAR2,
policy_name IN VARCHAR2);
Drops audit policy_name for object_name in object_schema.
PROCEDURE DBMS_FGA.ENABLE_POLICY
(object_schema IN VARCHAR2 DEFAULT NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2,
enable BOOLEAN DEFAULT TRUE);
Enables audit policy_name.
PROCEDURE DBMS_FGA.DISABLE_POLICY
(object_schema IN VARCHAR2 DEFAULT NULL,
object_name IN VARCHAR2,
policy_name IN VARCHAR2);
Disables audit policy_name.