PL/SQL Packages DBMS_RLS

Fine-grained access control administrative interface.
(available with Enterprise Edition only)

Subprocedures:

ADD_POLICY          Add a fine-grained access control policy to a table or view. 

DROP_POLICY         Drop a fine-grained access control policy from a table or view. 

REFRESH_POLICY      Cause all the cached statements associated with the policy to be reparsed. 

ENABLE_POLICY       Enable or disables a fine-grained access control policy. 

CREATE_POLICY_GROUP Create a policy group. 

ADD_GROUPED_POLICY  Add a policy associated with a policy group. 

ADD_POLICY_CONTEXT  Add the context for the active application. 

DELETE_POLICY_GROUP Delete a policy group. 

DROP_GROUPED_POLICY Drop a policy associated with a policy group. 

DROP_POLICY_CONTEXT Drop a driving context from the object so that it will have one less driving context. 

ENABLE__GROUPED_POLICY 
                    Enable or disables a row-level group security policy. 

REFRESH_GROUPED_POLICY
                    Reparse the SQL statements associated with a refreshed policy.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al


 
Copyright © 1999-2024 SS64.com
Some rights reserved