Oracle | SA_LABEL

Oracle SA_LABEL_ADMIN Version 21c

General Information

Library Note

Morgan's Library Page Header

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.

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