Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_RLS , 2 of 13
This procedure adds a fine-grained access control policy to a table or view.
The procedure causes the current transaction, if any, to commit before the operation is carried out. However, this does not cause a commit first if it is inside a DDL event trigger.
A commit is also performed at the end of the operation.
DBMS_RLS.ADD_POLICY ( object_schema IN VARCHAR2 := NULL, object_name IN VARCHAR2, policy_name IN VARCHAR2, function_schema IN VARCHAR2 := NULL, policy_function IN VARCHAR2, statement_types IN VARCHAR2 := NULL, update_check IN BOOLEAN := FALSE, enable IN BOOLEAN := TRUE);
SYS
is free of any security policy.
FUNCTION policy_function (object_schema IN VARCHAR2, object_name VARCHAR2) RETURN VARCHAR2 --- object_schema is the schema owning the table of view. --- object_name is the name of table of view that the policy will apply.
The maximum length of the predicate that the policy function can return is 32K.
WNDS
(write no database state).
The Oracle9i Application Developer's Guide - Fundamentals has more details about the
See Also:
RESTRICT_REFERENCES
pragma.
AND
ed) of all the predicates.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|