Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page