Oracle | LBAC

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