Oracle | SA_LABEL

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

AUTHID DEFINER

Dependencies

LBAC_CACHE	LBAC_STANDARD	OLS$LAB_LIBT
OLS_DIP_NTFY

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);

      

      PL/SQL procedure successfully completed.

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);

      

      PL/SQL procedure successfully completed.

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');

      

      PL/SQL procedure successfully completed.

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);

      

      PL/SQL procedure successfully completed.

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');

      

      PL/SQL procedure successfully completed.

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated: