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