OUD / OID / OVD - How to Identify the EUS User by Point of View of the Database Connection
(Doc ID 1962645.1)
Last updated on SEPTEMBER 23, 2021
Applies to:
Oracle Unified Directory - Version 11.1.2.2.0 and laterOracle 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>@<OUD_EUS_DB>
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>
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 |