Oracle | SA_DIP

Oracle OLS_DIP_NTFY Version 23c

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 This package is a notifier interface implemented by Label Security to receive information about OLS related changes in OID through the Directory Integration Provisioning system.

AUTHID DEFINER

Constants

Name	Data Type	Value
User Event Types
USER_ADD	VARCHAR2(32)	'USER_ADD'
USER_DELETE	VARCHAR2(32)	'USER_DELETE'
USER_MODIFY	VARCHAR2(32)	'USER_MODIFY'
Group Event Types
GROUP_ADD	VARCHAR2(32)	'GROUP_ADD
GROUP_DELETE	VARCHAR2(32)	'GROUP_DELETE'
GROUP_MODIFY	VARCHAR2(32)	'GROUP_MODIFY'
Identity Event Types
IDENTITY_ADD	VARCHAR2(32)	'IDENTITY_ADD'
IDENTITY_DELETE	VARCHAR2(32)	'IDENTITY_DELETE'
IDENTITY_MODIFY	VARCHAR2(32)	'IDENTITY_MODIFY'
Entry Event Types
ENTRY_ADD	VARCHAR2(32)	'ENTRY_ADD'
ENTRY_DELETE	VARCHAR2(32)	'ENTRY_DELETE'
ENTRY_MODIFY	VARCHAR2(32)	'ENTRY_MODIFY'
Subscriber Event Types
SUBSCRIBER_ADD	VARCHAR2(32)	'SUBSCRIBER_ADD'
SUBSCRIBER_DELETE	VARCHAR2(32)	'SUBSCRIBER_DELETE'
SUBSCRIBER_MODIFY	VARCHAR2(32)	'SUBSCRIBER_MODIFY'
Subscription Event Types
SUBSCRIPTION_ADD	VARCHAR2(32)	'SUBSCRIPTION_ADD'
SUBSCRIPTION_DELETE	VARCHAR2(32)	'SUBSCRIPTION_DELETE'
SUBSCRIPTION_MODIFY	VARCHAR2(32)	'SUBSCRIPTION_MODIFY'
Attribute Types
ATTR_TYPE_STRING	NUMBER	0
ATTR_TYPE_BINARY	NUMBER	1
Attribute Modification Types
MOD_ADD	NUMBER	0
MOD_DELETE	NUMBER	1
MOD_REPLACE	NUMBER	2
Event Dispositions
EVENT_SUCCESS	VARCHAR2(32)	'EVENT_SUCCESS'
EVENT_ERROR	VARCHAR2(32)	'EVENT_ERROR'
EVENT_RESEND	VARCHAR2(32)	'EVENT_RESEND'
Event Dispositions
EVENT_FOUND	NUMER	0
EVENT_NOT_FOUND	NUMBER	1403

Data Types lbacsys.ldap_attr_list Name Type ------------------- ------------- ATTR_NAME VARCHAR2(256) ATTR_VALUE VARCHAR2(4000) ATTR_BVALUE BLOB ATTR_VALUE_LEN NUMBER(38) ATTR_TYPE NUMBER(38) ATTR_MOD_OP NUMBER(38) lbacsys.ldap_event Name Type ------------------- ------------- EVENT_TYPE VARCHAR2(32) EVENT_ID VARCHAR2(32) EVENT_SRC VARCHAR2(1024) EVENT_TIME VARCHAR2(32) OBJECT_NAME VARCHAR2(1024) OBJECT_TYPE VARCHAR2(32) OBJECT_GUID VARCHAR2(32) OBJECT_DN VARCHAR2(1024) PROFILE_ID VARCHAR2(1024) ATTR_LIST lbacsys.ldap_attr_list lbacsys.ldap_event_status Name Type ------------------- ------------- EVENT_ID VARCHAR2(32) ORCLGUID VARCHAR2(32) ERROR_CODE NUMBER(38) ERROR_STRING VARCHAR2(1024) ERROR_DISPOSITION VARCHAR2(32)

Dependencies

DBA_SA_COMPARTMENTS	LDAP_ATTR_LIST	OLS$PROPS
DBA_SA_GROUPS	LDAP_EVENT	OLS$USER_LEVELS
DBA_SA_LABELS	LDAP_EVENT_STATUS	PLITBLM
DBA_SA_LEVELS	OLS$DIP_DEBUG	SA_AUDIT_ADMIN
DBA_SA_POLICIES	OLS$DIP_EVENTS	SA_COMPONENTS
DBA_SA_USER_LABELS	OLS$LAB	SA_LABEL_ADMIN
LBAC_CACHE	OLS$POLICY_ADMIN	SA_SYSDBA
LDAP_ATTR	OLS$PROFILES	SA_USER_ADMIN

Documented Yes

First Available 10.1

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE)

Security Model Owned by LBACSYS with EXECUTE granted to DIP.

Source

Bug opened 6-Aug-2023 In 23c this package is not installed by default and can be found in $ORACLE_HOME/rdbms/admin/olse21.sql

Warning: Running this script resulted in PDB$SEED and other PDBs becoming invalid and no fix was found so do not run the olse21 script.

The package, once created can be dropped with olsu21.sql but doing this did not fix the issues with PDB$SEED or other other PDBs.

Subprograms

An event from the Application Database to OID ols_dip_ntfy.getAppEvent( eventid IN OUT VARCHAR2, event OUT lbacsys.ldap_event) RETURN NUMBER;

TBD

PUTAPPEVENTSTATUS

Application event status ols_dip_ntfy.putAppEventStatus(event_status IN lbacsys.ldap_event_status);

TBD

PUTOIDEVENT

An event from OID to the Application Database ols_dip_ntfy.putOIDEvent( event IN lbacsys.ldap_event, event_Status IN lbacsys.ldap_event_status);

TBD

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

DBSecWorx