To receive the real benefit of the enterprise user solution, you can use shared schemas for your enterprise users. For this strategy, complete the following tasks:
Create enterprise users in the directory
Create a single shared schema in each database
Create a single shared schema mapping in Oracle Internet Directory
Mapping enterprise users to a generic, shared schema on each of the databases that they access greatly reduces the overhead of creating separate schemas for each enterprise user.
Shared schema enterprise users can be mapped to generic, shared schemas on all of the databases that they access, or they can have exclusive schemas on some databases and shared schemas on others. The shared schema mappings are stored in the directory.
See Also:
"About Using Shared Schemas for Enterprise User Security" for more information about creating and using shared schemas for enterprise users
"Creating a Shared Schema in the Database" for a tutorial on creating a shared schema in the database