Provision Impersonate User for Connections to Oracle BI EE On-Premises

You can provision the impersonate user functionality in Oracle Fusion Middleware when your Oracle Application connection target is an on-premises installation of Oracle BI EE.

1. Log in to Oracle Fusion Middleware Control for your Oracle BI EE instance using an administrator account.
2. Click the Weblogic Domain option, and select Security and Application Policies.
3. Click Create to display the Create Application Grant dialog.
4. Click (+) Add in the Permissions area.
5. Select Resource Types.
6. Select oracle.bi.user from the drop-down list.
7. Click Continue.
8. Enter an asterisk (*) in the Resource Name field.
9. Select "impersonate" in Permission Actions.
10. Click Select.
11. Click (+) Add in the Grantee section.
12. Select User from the Type drop-down list.

    You grant the newly created permission to either an application role or user.

13. Select Includes from the Principal Name drop-down list and enter an asterisk (*) into the field.
14. Click the > arrow to display a list of users.
15. Select the user that you want to give the permission to and click OK.

    You can now test the impersonate functionality.