Oracle | DBMS_RLS_INT

Oracle DBMS_RLS_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Internal support for DBMS_RLS and Row Level Security. There is a 1:1 correspondence between the objects in this package and objects in the DBMS_RLS package that is link at page bottom.

AUTHID DEFINER

Dependencies

DBMS_RLS

DBMS_RLS_LIB

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvtrlsa.plb

Subprograms

ADD_GROUPED_POLICY	CREATE_POLICY_GROUP	DROP_POLICY_CONTEXT
ADD_POLICY	DELETE_POLICY_GROUP	ENABLE_GROUPED_POLICY
ADD_POLICY_CONTEXT	DISABLE_GROUPED_POLICY	ENABLE_POLICY
ALTER_GROUPED_POLICY	DROP_GROUPED_POLICY	REFRESH_GROUPED_POLICY
ALTER_POLICY	DROP_POLICY	REFRESH_POLICY

ADD_GROUPED_POLICY

Add a row level security policy to a policy group for a table or view dbms_rls_int.add_grouped_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_group IN VARCHAR2, policy_name IN VARCHAR2, function_schema IN VARCHAR2, policy_function IN VARCHAR2, statement_types IN VARCHAR2, update_check IN BOOLEAN, enable IN BOOLEAN, static_policy IN BOOLEAN, policy_type IN BINARY_INTEGER, long_predicate IN BOOLEAN, sec_relevant_cols IN VARCHAR2, sec_relevant_cols_opt IN BINARY_INTEGER, namespace IN VARCHAR2, attribute IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

Add a row level security policy to a table or view dbms_rls_int.add_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, function_schema IN VARCHAR2, policy_function IN VARCHAR2, statement_types IN VARCHAR2, update_check IN BOOLEAN, enable IN BOOLEAN, static_policy IN BOOLEAN, policy_type IN BINARY_INTEGER, long_predicate IN BOOLEAN, sec_relevant_cols IN VARCHAR2, sec_relevant_cols_opt IN BINARY_INTEGER, namespace IN VARCHAR2, attribute IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

ADD_POLICY_CONTEXT

Add a driving context to a table or view dbms_rls_int.add_policy_context( object_schema IN VARCHAR2, object_name IN VARCHAR2, namespace IN VARCHAR2, attribute IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

ALTER_GROUPED_POLICY

Alter a row level security policy of a policy group dbms_rls_int.alter_grouped_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_group IN VARCHAR2, policy_name IN VARCHAR2, alter_option IN BINARY_INTEGER, namespace IN VARCHAR2, attribute IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

Alter a row level security policy dbms_rls_int.alter_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, alter_option IN BINARY_INTEGER, namespace IN VARCHAR2, attribute IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

CREATE_POLICY_GROUP

Create a policy group for a table or view dbms_rls_int.create_policy_group( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_group IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

DELETE_POLICY_GROUP

Delete a policy group for a table or view dbms_rls_int.delete_policy_group( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_group IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

DISABLE_GROUPED_POLICY

Enable or disable a policy for a table or view dbms_rls_int.disable_grouped_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, group_name IN VARCHAR2, policy_name IN VARCHAR2, enable IN BOOLEAN, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

DROP_GROUPED_POLICY

Drop a row level security policy from a policy group of a table or view dbms_rls_int.drop_grouped_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_group IN VARCHAR2, policy_name IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

Drop a row level security policy from a table or view dbms_rls_int.drop_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

DROP_POLICY_CONTEXT

Drop a driving context from a table or view dbms_rls_int.drop_policy_context( object_schema IN VARCHAR2, object_name IN VARCHAR2, namespace IN VARCHAR2, attribute IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

ENABLE_GROUPED_POLICY

Enable or disable a policy for a table or view dbms_rls_int.enable_grouped_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, group_name IN VARCHAR2, policy_name IN VARCHAR2, enable IN BOOLEAN, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

Enable or disable a security policy for a table or view dbms_rls_int.enable_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, enable IN BOOLEAN, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

REFRESH_GROUPED_POLICY

Invalidate all cursors associated with the policy. If no argument provides, all cursors with policies involved will be invalidated. dbms_rls.refresh_grouped_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, group_name IN VARCHAR2, policy_name IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

Invalidate all cursors associated with the policy. If no argument provides, all cursors with policies involved will be invalidated. dbms_rls_int.refresh_policy( object_schema IN VARCHAR2, object_name IN VARCHAR2, policy_name IN VARCHAR2, cps IN BOOLEAN);

See corresponding entry on the DBMS_RLS page

Related Topics

Built-in Functions

Built-in Packages

What's New In 21c

What's New In 23c

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved