Oracle LBAC_RLS
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
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');
*
ORA-12414: internal LBAC error: check_filter
 
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');
*
ORA-12414: internal LBAC error: readcheck_filter
 
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');
*
ORA-12414: internal LBAC error: readcheck_filter2
 
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');
*
ORA-12414: internal LBAC error: read_filter

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