Oracle | SEM

Oracle SEM_OLS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Provides an interface for applying triple-level security to RDF data using Oracle Label Security (OLS).

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
General
MIN_QUERY_LABEL	VARCHAR2(100)	'MIN_QUERY_LABEL'
INTERIM_BREAK_UP_FCN_NAME	VARCHAR2(32767	'ORACLE_ORARDF_BREAK_UP_TRIPLE'

Dependencies

ALL_OBJECTS	MDERR	SDO_SEM_CTX
ALL_PROCEDURES	ODCINUMBERLIST	SDO_SEM_CTX_SESSION
DBMS_ASSERT	ODCIVARCHAR2LIST	SDO_SEM_LOG
DBMS_REGISTRY	PLITBLM	SEM__OLS_DR
DBMS_STANDARD	RDF_APIS	SEM_RDFSA
DBMS_SYSTEM	RDF_APIS_INTERNAL	SEM_RDFSA_DR
DBMS_UTILITY	SDO_RDF_INTERNAL	SEM_RDFSA_PRIV

Documented Yes

Exceptions

Error Code	Reason
ORA-55356	`ORA-553356: OLS not enabled for RDF data`

First Available Not known

Pragma SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by MDSYS with EXECUTED granted to PUBLIC.

Source {ORACLE_HOME}/md/admin/sdordfsa.sql
{ORACLE_HOME}/md/admin/pvtrdfsa.plb

Subprograms

APPLY_OLS_POLICY	GET_MIN_LABEL_FOR_QUERY
APPLY_POLICY_TO_APP_TAB	REMOVE_OLS_POLICY
COPY_NETWORK_INFO_TO_PKG_VARS	REMOVE_POLICY_FROM_APP_TAB
DISABLE_OLS_POLICY	SET_MIN_LABEL_FOR_QUERY
ENABLE_OLS_POLICY

APPLY_OLS_POLICY

Apply OLS policy for RDF data sem_ols.apply_ols_policy( policy_name IN VARCHAR2, rdfsa_options IN NUMBER, table_options IN VARCHAR2 DEFAULT 'ALL_CONTROL', predicate IN VARCHAR2 DEFAULT NULL);

TBD

APPLY_POLICY_TO_APP_TAB

Undocumented sem_ols.apply_policy_to_app_tab( policy_name IN VARCHAR2, schema_name IN VARCHAR2, table_name IN VARCHAR2, predicate IN VARCHAR2 DEFAULT NULL, network_owner IN VARCHAR2 DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL);

TBD

COPY_NETWORK_INFO_TO_PKG_VARS

Undocumented sem_ols.copy_network_info_to_pkg_vars;

TBD

DISABLE_OLS_POLICY

Disable OLS policy for RDF data sem_ols.disable_ols_policy;

TBD

ENABLE_OLS_POLICY

Enable OLS policy after disabling sem_ols.enable_ols_policy;

exec sem_ols.enable_ols_policy;

           *

      ORA-55356: OLS not enabled for RDF data

GET_MIN_LABEL_FOR_QUERY

Undocumented sem_ols.get_min_label_for_query RETURN VARCHAR2;

TBD

REMOVE_OLS_POLICY

Remove the OLS policy for RDF data sem_ols.remove_ols_policy;

TBD

REMOVE_POLICY_FROM_APP_TAB

Undocumented sem_ols.remove_policy_from_app_tab( policy_name IN VARCHAR2, schema_name IN VARCHAR2, table_name IN VARCHAR2, check_model IN BOOLEAN DEFAULT TRUE, network_owner IN VARCHAR2 DEFAULT NULL, network_name IN VARCHAR2 DEFAULT NULL);

TBD

SET_MIN_LABEL_FOR_QUERY

Undocumented sem_ols.set_min_label_for_query(label_name IN VARCHAR2);

TBD