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
 
GETAPPEVENT
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
LBAC_EVENTS
LBAC_EXP
LBAC_POLICY_ADMIN
LBAC_POLICY_ADMIN_INT
LBAC_SESSION
LBAC_STANDARD
LBAC_SYSDBA
OLS$DATAPUMP
OLS_ENFORCEMENT
OLS_UTIL_WRAPPER
Oracle Label Security (OLS)
SA_COMPONENTS
SA_LABEL_ADMIN
SA_SYSDBA
SA_USER_ADMIN
TO_LABEL_LIST
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx