Oracle | LBAC_POLICY_ADMIN

Oracle LBAC_POLICY_ADMIN_INT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Oracle Label Security Internal Policy Administration Utilities

AUTHID CURRENT_USER

Dependencies

ALL_USERS	LBAC_NAME_LIST	LBAC_STANDARD
LBAC$USER_LIBT	LBAC_POLICY_ADMIN	OLS$POLS
LBAC_CACHE	LBAC_SERVICES

Documented No

First Available 20c

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvtolsdd.plb

Subprograms

ALTER_SCHEMA_POLICY	DISABLE_TABLE_POLICY	POLICY_UNSUBSCRIBE
APPLY_SCHEMA_POLICY	ENABLE_SCHEMA_POLICY	REMOVE_SCHEMA_POLICY
APPLY_TABLE_POLICY	ENABLE_TABLE_POLICY	REMOVE_TABLE_POLICY
DISABLE_SCHEMA_POLICY	POLICY_SUBSCRIBE

ALTER_SCHEMA_POLICY

Modify a schema policy lbac_policy_admin_int.alter_schema_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, default_options IN VARCHAR2, username IN VARCHAR2);

TBD

APPLY_SCHEMA_POLICY

Apply a schema policy lbac_policy_admin_int.apply_schema_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, default_options IN VARCHAR2, username IN VARCHAR2)

TBD

APPLY_TABLE_POLICY

Apply a table policy lbac_policy_admin_int.apply_table_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, table_name IN VARCHAR2, table_options IN VARCHAR2, label_function IN VARCHAR2, predicate IN VARCHAR2, username IN VARCHAR2);

TBD

DISABLE_SCHEMA_POLICY

Disable a schema policy lbac_policy_admin_int.disable_schema_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, username IN VARCHAR2);

exec lbac_policy_admin_int.disable_schema_policy('DATA_ACCESS', 'HR', 'UWCLASS');

DISABLE_TABLE_POLICY

Disable a table policy lbac_policy_admin_int.disable_table_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, table_name IN VARCHAR2, username IN VARCHAR2);

exec lbac_policy_admin_int.disable_table_policy('DATA_ACCESS', 'HR', 'EMPLOYEES', 'UWCLASS');

ENABLE_SCHEMA_POLICY

Enable a schema policy lbac_policy_admin_int.enable_schema_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, username IN VARCHAR2);

exec lbac_policy_admin_int.enable_schema_policy('DATA_ACCESS', 'HR', 'UWCLASS');

ENABLE_TABLE_POLICY

Enable a table policy lbac_policy_admin_int.enable_table_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, table_name IN VARCHAR2, username IN VARCHAR2);

exec lbac_policy_admin_int.enable_table_policy('DATA_ACCESS', 'HR', 'EMPLOYEES', 'UWCLASS');

POLICY_SUBSCRIBE

Subscribe to a policy lbac_policy_admin_int.policy_subscribe( policy_name IN VARCHAR2, username IN VARCHAR2);

exec lbac_policy_admin_int.policy_subscribe('DATA_ACCESS', 'UWCLASS');

POLICY_UNSUBSCRIBE

Unsubscribe from a policy lbac_policy_admin_int.policy_unsubscribe( policy_name IN VARCHAR2, username IN VARCHAR2);

exec lbac_policy_admin_int.policy_unsubscribe('DATA_ACCESS', 'UWCLASS');

REMOVE_SCHEMA_POLICY

Remove a schema policy lbac_policy_admin_int.remove_schema_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, drop_column IN BOOLEAN, username IN VARCHAR2);

TBD

REMOVE_TABLE_POLICY

Remove a table policy lbac_policy_admin_int.remove_table_policy( policy_name IN VARCHAR2, schema_name IN VARCHAR2, table_name IN VARCHAR2, drop_column IN BOOLEAN, username IN VARCHAR2);

TBD

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated: