How to Identify the EUS User by Point of View of The database Connection? (Doc ID 1962645.1)

Last updated on JANUARY 11, 2017

Applies to:

Oracle Unified Directory - Version 11.1.2.2.0 and later
Oracle Internet Directory - Version 11.1.1 and later
Oracle Directory Server Enterprise Edition - Version 11.1.1.7.0 and later
Oracle Virtual Directory - Version 11.1.2.0 and later
Information in this document applies to any platform.

Goal

Identify which EUS user is connected on Database

After you have configured  OUD and EUS and you have mapped EUS user with the global_ident_schema_user as describe in Documentation http://docs.oracle.com/cd/B28359_01/network.111/b28528/getstrtd.htm#DBIMI237

How to verify who EUS/ldap user is connected on Database

Example:

sqlplus user.20/secret12@oudeusdb

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 20 11:57:32 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show user
USER is "GLOBAL_OUD_SCHEMA_USER"
SQL>

 

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms