| General Information |
| Library Note |
|
| 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 LBACSYS with no privileges granted |
| 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); |