My Oracle Support Banner

Enterprise User Security Frequently Asked Questions (Doc ID 1363975.1)

Last updated on APRIL 09, 2020

Applies to:

Advanced Networking Option - Version 11.2 to 12.1.0.2
Information in this document applies to any platform.

Purpose

This document answers questions which are frequently asked regarding the concepts, configuration, maintenance, and troubleshooting of Enterprise User Security.

Questions and Answers

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
Purpose
Questions and Answers
 (A) Introduction 
 1. What is Enterprise User Security ?
 2. How EUS works ?
 3. Does centralized user management fit all models of client-server application architecture ?
 4. What authentication mechanisms are supported by Enterprise User Security ?
 5. What are SSL and Non-SSL ports (in ldap.ora) used for?
 6. How to remove a database from EUS?
 6. Can a database be registered with two different Directory Servers (e.g. two OIDs or one OID and another OUD/OVD)?
 (B) Shared and Exclusive Schema
 1. What's the difference between Shared and Exclusive Schema?
 2. How the Shared and Exclusive Schema are created?
 3. How to check if an Enterprise User is connected through an Exclusive Schema or a Shared Schema?
 4. Do we have to create a shared schema in every database that an enterprise user might access ?
 5. Can an Enterprise User own any objects in the database ?
 6. Is it recommended to create application objects in the shared schema ?
 (C) Proxy permissions for Enterprise User
 1. Can an Enterprise User connect as a proxy user?
 2. How to configure an Enterprise user to connect as a proxy user?
 (D) Password Policy
 1. For password authenticated Enterprise Users where are the user's database passwords stored ?
 2. Do password authenticated Enterprise Users get single sign on to the database since the passwords are centrally located ?
 3. How are passwords changed for password authenticated Enterprise Users ?
 4. Does Oracle Internet Directory's password management policies apply to database passwords as well ?
 (E) Configuring EUS with Dataguard,RAC and Multitenant env.
 1. What are the steps to configure EUS in a DG env. ?
 2. Do we need to register all the nodes of RAC with Directory using DBCA?
 3. How to configure EUS in a Multitenant env.?
 (F) Miscellaneous
 1. Do Enterprise Users work across database links ?
 2. How can Enterprise Users be audited?
 3. How can Database users be migrated to Oracle Internet Directory ?
 4. Can Oracle Enterprise Manager Express be used to configure EUS for a 12.1 Database ?
 5. Is it possible to configure Enterprise User Security against LDAP servers provided by a 3rd party?
 6. Does EUS support the TLS protocol ?
 7. What is the best practice to register multiple databases to a Directory ?
 8. Can Oracle Label Security policies be applied to Enterprise Users ?
 9. If a user has different login names for the different applications (in different databases) will they be able to go with one login name for all of the databases ?
References

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