My Oracle Support Banner

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

Last updated on MARCH 26, 2019

Applies to:

Oracle Unified Directory - Version 11.1.2.2.0 and later
Oracle Internet Directory - Version 11.1.1 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 to the Database

After configuring  OUD and EUS and mapping the EUS user with the global_ident_schema_user as describe in -

Creating a Shared Schema in the Database

 

How to verify the EUS/ldap user connected to the Database

Example:

sqlplus user.20/<PASSWORD>@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>

 In the example above, the user is "GLOBAL_OUD_SCHEMA_USER but is not EUS/ldap user.20.

 

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.