Oracle | DBMS_RLS_INT

Oracle DBMS_RLS_INT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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 EXECUTE granted to the OGG_APPLY_PROCREP role.

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 26ai

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated:

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