Database Schema Mapping

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:

  1. Click the name of a database.

  2. Review the Database Schema Mapping page.

  3. Click Browse Directory.

  4. Type the naming context under which you want to perform a search, or click Advanced Search to select the directory search attributes you want to search.

  5. Click Search Directory.

  6. Click the directory entry you want to use.

  7. Click OK.

  8. You are returned to the Database Schema Mapping page.

  9. Click Apply to confirm your changes, or click Revert to discard your changes.