Oracle LBAC_RLS
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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_CACHE
LBAC_EVENTS
LBAC_EXP
LBAC_POLICY_ADMIN
LBAC_POLICY_ADMIN_INT
LBAC_SESSION
LBAC_STANDARD
LBAC_SYSDBA
OLS$DATAPUMP
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 21c
What's New In 23c

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