Oracle LBAC_POLICY_ADMIN / SA_POLICY_ADMIN
Version 20c

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 utility for managing schema and table policies.

SA_POLICY_ADMIN is a Public Synonym for LBAC_POLICY_ADMIN.
AUTHID DEFINER
Dependencies
ALL_USERS LBAC_SERVICES OLS$POLS
LBAC$USER_LIBT LBAC_STANDARD OLS$POLT
LBAC_CACHE OLS$POL SA_POLICY_ADMIN
LBAC_NAME_LIST    
Documented Yes
First Available 10.1
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtolsdd.plb
Subprograms
 
ALTER_SCHEMA_POLICY
Alters the default options of a label security schema policy lbac_policy_admin.alter_schema_policy(
policy_name     IN VARCHAR2,
schema_name     IN VARCHAR2,
default_options IN VARCHAR2);
TBD
 
APPLY_SCHEMA_POLICY
Applies a label security schema policy lbac_policy_admin.apply_schema_policy(
policy_name     IN VARCHAR2,
schema_name     IN VARCHAR2,
default_options IN VARCHAR2);
TBD
 
APPLY_TABLE_POLICY
Applies a label security table policy lbac_policy_admin.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);
TBD
 
DISABLE_SCHEMA_POLICY
Disable a table security schema policy lbac_policy_admin.disable_schema_policy(
policy_name IN VARCHAR2,
schema_name IN VARCHAR2);
exec lbacsys.lbac_policy_admin.disable_schema_policy('DATA_ACCESS', 'UWCLASS');
 
DISABLE_TABLE_POLICY
Disable a table security table policy lbac_policy_admin.disable_table_policy(
policy_name IN VARCHAR2,
schema_name IN VARCHAR2,
table_name  IN VARCHAR2);
exec lbacsys.lbac_policy_admin.disable_table_policy('DATA_ACCESS', 'UWCLASS', 'AIRPLANES');
 
ENABLE_SCHEMA_POLICY
Enables a label security schema policy lbac_policy_admin.enable_schema_policy(
policy_name IN VARCHAR2,
schema_name IN VARCHAR2);
exec lbac_policy_admin.enable_schema_policy('DATA_ACCESS', 'UWCLASS');
 
ENABLE_TABLE_POLICY
Enables a label security table policy lbac_policy_admin.enable_table_policy(
policy_name IN VARCHAR2,
schema_name IN VARCHAR2,
table_name  IN VARCHAR2);
exec lbacsys.lbac_policy_admin.enable_table_policy('DATA_ACCESS', 'UWCLASS', 'AIRPLANES');
 
POLICY_SUBSCRIBE
Subscribes to a label security policy lbac_policy_admin.policy_subscribe(policy_name IN VARCHAR2);
exec lbacsys.lbac_policy_admin.policy_subscribe('DATA_ACCESS');
 
POLICY_UNSUBSCRIBE
Unsubscribes from a label security policy lbac_policy_admin.policy_unsubscribe(policy_name IN VARCHAR2);
exec lbacsys.lbac_policy_admin.policy_unsubscribe('DATA_ACCESS');
 
REMOVE_SCHEMA_POLICY
Removes the label security policy from a schema lbac_policy_admin.remove_schema_policy(
policy_name IN VARCHAR2,
schema_name IN VARCHAR2,
drop_column IN BOOLEAN);
exec lbacsys.lbac_policy_admin.remove_schema_policy('DATA_ACCESS', 'UWCLASS', TRUE);
 
REMOVE_TABLE_POLICY
Removes the label security policy from a table lbac_policy_admin.remove_table_policy(
policy_name   IN VARCHAR2,
schema_name   IN VARCHAR2,
table_name    IN VARCHAR2,
drop_column   IN BOOLEAN);
exec lbacsys.lbac_policy_admin.remove_table_policy('DATA_ACCESS', 'UWCLASS', 'AIRPLANES', TRUE);

Related Topics
LBAC_EXP
LBAC_SESSION
LBAC_STANDARD
LBAC_SYSDBA
OLS$DATAPUMP
OLS_DIP_NTFY
OLS_ENFORCEMENT
OLS_UTIL_WRAPPER
Oracle Label Security (OLS)
SA_COMPONENTS
SA_LABEL_ADMIN
SA_SYSDBA
SA_USER_ADMIN
TO_LABEL_LIST