Oracle | LBAC

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	INVKZSCO	READCHECK_FILTER2
CLEARHT	READCHECK_FILTER	READ_FILTER

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

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx