Proxy permissions allow an enterprise user to proxy a local database user, which means that the enterprise user can log in to the database as the local database user. You can grant proxy permissions to individual users or groups. Proxy permissions are especially useful for middle tier applications that operate across multiple databases as enterprise users.
Proxy permissions are created at the enterprise domain level. After creating a proxy permission for an enterprise domain, you can grant it to an enterprise user.
To grant proxy permissions to enterprise users:
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 Proxy Permissions tab.
Click Grant.
The Select Proxy Permissions window appears.
Select the Proxy Permission to be granted. The proxy permission must have already been created for the enterprise domain. Click Select.
Click OK in the Configure User page.