Oracle DBMS_RLS_INT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 (new 12.2)
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 12cR1
What's New In 12cR2

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