Oracle | SA_LABEL

Oracle SA_LABEL_ADMIN 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 Use this package to create, alter and drop OLS labels.

AUTHID DEFINER

Dependencies

LBAC_CACHE	OLS$LAB_LIBT	OLS_DIP_NTFY
LBAC_STANDARD

Documented Yes

First Available 10.1

Security Model Owned by LBACSYS with no privileges granted.

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

Subprograms

Alter a policy label by tag

Overload 1 sa_label_admin.alter_label( policy_name IN VARCHAR2, label_tag IN BINARY_INTEGER, new_label_value IN VARCHAR2, new_data_label IN BOOLEAN); -- valid values TRUE & NULL

exec sa_label_admin.alter_label('FACILITY', -3401, -3301, TRUE);

Alter a policy label by value

Overload 2 sa_label_admin.alter_label( policy_name IN VARCHAR2, label_value IN VARCHAR2, new_label_value IN VARCHAR2, new_data_label IN BOOLEAN); -- valid values TRUE & NULL

exec sa_label_admin.alter_label('FACILITY', 'C::APAC', 'C::NATO', TRUE);

CREATE_LABEL

Create a policy label sa_label_admin.create_label( policy_name IN VARCHAR2, label_tag IN BINARY_INTEGER, label_value IN VARCHAR2, data_label IN BOOLEAN); -- valid values TRUE & NULL

exec sa_label_admin.create_label('FACILITY', -3301, 'C::APAC');

DROP_LABEL

Drop a policy label by tag

Overload 1 sa_label_admin.drop_label( policy_name IN VARCHAR2, label_tag IN BINARY_INTEGER);

exec sa_label_admin.drop_label('FACILITY', -3301);

Drop a policy label by value

Overload 2 sa_label_admin.drop_label( policy_name IN VARCHAR2, label_value IN VARCHAR2);

exec sa_label_admin.drop_label('FACILITY', 'C::APAC');

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx