A user-schema mapping maps an enterprise user to a global database schema. When the enterprise user logs in to the database, he is connected to the mapped schema, by default.
To create a user-schema mapping:
Log in to Enterprise Manager Cloud Control, as an administrative user.
To navigate to your database, select Databases from the Targets menu.
Click the database name in the list that appears. The database page appears.
Under the Administration menu, select Security, Enterprise User Security. The Oracle Internet Directory Login page appears.
Enter the distinguished name (DN) of a directory user who can administer enterprise users in the User field. Enter the user password in the Password field. Click Login.
The Enterprise User Security page appears.
Click Configure Enterprise Users.
The Configure Enterprise Users page appears.
Select the Search Base in which the enterprise user is located. The search base is the subtree which contains the enterprise user entry. You can optionally enter the common name of the enterprise user in the Name field. Select User in the View box. Click Go.
A list of users with matching criteria appears.
Select the enterprise user that you wish to configure. Click Configure.
The Configure User page appears.
Click the User-Schema Mappings tab. All user-schema maps that apply to the user directly or indirectly are displayed.
A user can be individually mapped to a schema. Alternatively, you can map a directory subtree containing multiple users to the database schema.
Click Create.
The Create Mapping page is displayed.
Under the From section, select Users to map an individual enterprise user to a database schema. Alternatively, select Subtree to map a directory subtree containing multiple users.
Under To, select Database to map to a database schema. Select Domain to map to a schema common to all databases in the enterprise domain.
You can have multiple databases in an enterprise domain that have a common schema name. When you map an enterprise user to such a schema, the enterprise user is automatically mapped to the individual schemas in each database contained in the domain.
If you selected Database in the preceding step, then select the name of the database that contains the schema. Next, enter the database schema name. You can also use the search icon to select the schema. You will be required to log in to the database to select the schema.
If you selected Domain in the preceding step, then select the name of the domain and enter the common schema name in the Schema field.
Click Continue in the Create Mapping page.
Click OK in the Configure User page.