Use Oracle Enterprise Security Manager to manage database user schema separation. User schema separation, new in Oracle8i, is a concept in which the authenticated identity of a database user does not need to match the name of the database schema to which the user connects.
The directory you use stores a map of sets of directory user identities to basic schema names on databases. There are two levels of this type of mapping; they are:
Domain Level - All Directory Users whose Distinguished Names match a "Partial Distinguished Name" map to one common database schema name.
Database Level - One Directory User with a particular Distinguished Name will map to one database schema name.
Map a schema to a directory entry as follows: