Oracle LBAC_RLS
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 Label Security utilities for Row Level Security (DBMS_RLS, Virtual Private Database)
AUTHID DEFINER
Dependencies
LBAC$RLS_LIBT LBAC_EVENTS LBAC_STANDARD
Documented No
Exceptions
Error Code Reason
ORA-12414 Internal LBAC error: <string>
First Available Not Known but likely 12.2
Security Model Owned by LBACSYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvtolsdd.plb
Subprograms
 
CHECK_FILTER
Undocumented lbac_rls.check_filter(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2)
RETURN VARCHAR2;
SELECT lbacsys.lbac_rls.check_filter('SECDEMO', 'EMPLOYEE')
FROM dual;
SELECT lbacsys.lbac_rls.check_filter('SECDEMO', 'EMPLOYEE')
*
ERROR at line 1:
ORA-12414: internal LBAC error: check_filter
Error:
ORA-06512: at "LBACSYS.LBAC_STANDARD", line 20
ORA-06512: at "LBACSYS.LBAC_RLS", line 30
 
CLEARHT
Undocumented lbac_rls.clearht;
exec lbacsys.lbac_rls.clearht;

PL/SQL procedure successfully completed.
 
INVKZSCO
Undocumented lbac_rls.invkzsco(pid IN BINARY_INTEGER);
SELECT pid, pname, username
FROM v$process
WHERE pname LIKE 'MM%';

       PID PNAME USERNAME
---------- ----- -----------
         7 MMAN  oracle
        34 MMON  oracle
        35 MMNL  oracle

exec lbacsys.lbac_rls.invkzsco(35);

PL/SQL procedure successfully completed.
 
READCHECK_FILTER
Undocumented lbac_rls.readcheck_filter(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2)
RETURN VARCHAR2;
SELECT lbacsys.lbac_rls.readcheck_filter('SECDEMO', 'EMPLOYEE')
FROM dual;
SELECT lbacsys.lbac_rls.readcheck_filter('SECDEMO', 'EMPLOYEE')
*
ERROR at line 1:
ORA-12414: internal LBAC error: readcheck_filter
Error:
ORA-06512: at "LBACSYS.LBAC_STANDARD", line 20
ORA-06512: at "LBACSYS.LBAC_RLS", line 40
 
READCHECK_FILTER2
Undocumented lbac_rls.readcheck_filter2(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2)
RETURN VARCHAR2;
SELECT lbacsys.lbac_rls.readcheck_filter2('SECDEMO', 'EMPLOYEE')
FROM dual;
SELECT lbacsys.lbac_rls.readcheck_filter2('SECDEMO', 'EMPLOYEE')
*
ERROR at line 1:
ORA-12414: internal LBAC error: readcheck_filter2
Error:
ORA-06512: at "LBACSYS.LBAC_STANDARD", line 20
ORA-06512: at "LBACSYS.LBAC_RLS", line 50
 
READ_FILTER
Undocumented lbac_rls.read_filter(
schema_name IN VARCHAR2,
table_name  IN VARCHAR2)
RETURN VARCHAR2;
SELECT lbacsys.lbac_rls.read_filter('SECDEMO', 'EXP_REPORT_SUM_VIEW')
FROM dual;
SELECT lbacsys.lbac_rls.read_filter('SECDEMO', 'EMPLOYEE')
*
ERROR at line 1:
ORA-12414: internal LBAC error: read_filter
Error:
ORA-06512: at "LBACSYS.LBAC_STANDARD", line 20
ORA-06512: at "LBACSYS.LBAC_RLS", line 20

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_RLS
LBAC_EVENTS
LBAC_EXP
LBAC_POLICY_ADMIN
LBAC_POLICY_ADMIN_INT
LBAC_SESSION
LBAC_STANDARD
LBAC_SYSDBA
OLS$DATAPUMP
OLS_DIP_NTFY
OLS_ENFORCEMENT
OLS_UTIL_WRAPPER
Oracle Label Security (OLS)
SA_COMPONENTS
SA_LABEL_ADMIN
SA_SYSDBA
SA_USER_ADMIN
TO_LABEL_LIST
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
  DBSecWorx