Oracle DBMS_RLS_INT
Version 18.3

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.0.1
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvtrlsa.plb
Subprograms
 
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_POLICY
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_POLICY
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_POLICY
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_POLICY
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
 
REFRESH_POLICY
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
DBMS_RLS
What's New In 18c
What's New In 19c

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
  DBSecWorx