Oracle | DBMS_RLS_INT

Oracle DBMS_RLS_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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 19c

What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved