|Oracle® Fusion Middleware Administrator's Guide for Oracle Business Intelligence Discoverer
11g Release 1 (11.1.1)
Part Number B32519-01
Use the Create EUL Wizard to help you create a new End User Layer (EUL). In this dialog you define the owner of the new EUL.
For more information, see:
Who will own the EUL?
Select an existing user
Use this option to create an EUL for an existing database user in the current database. Select the database user from the User drop down list.
Note: If the database user already owns an EUL, the new EUL will replace the existing EUL.
Create a new user
Use this option to create a new database user and an EUL for that database user. You must have sufficient database privileges to create a new user (for more information, see "What privileges do you require to create an End User Layer in an Oracle database?").
Grant EUL access to PUBLIC
Select this check box to specify that the new EUL is accessible to all users in the current database.
Clear this check box to specify that the EUL owner is the only database user that is able to access data through this EUL.
Note: It is recommended that you clear the Grant EUL access PUBLIC check box, where security is an issue. The EUL owner can subsequently define business area access and privileges for users and roles or responsibilities as required (for more information, see "Controlling Access to Information").
New EUL is for use by Oracle Applications users ONLY
Select this check box to restrict EUL access to Oracle Applications users. Clear this check box to create a standard EUL.
Note: The choice that you make here is final. You cannot change a standard EUL into an Oracle Applications EUL (and vice versa).
Enter the EUL user's password
If you want a new database user to own the new EUL, use this field to enter a username for the new database user. A new database user will be created.
If you want an existing database user to own the new EUL, use this button to display the "Select User dialog" where you can search for and select the database user that will own the new EUL.
If you want a new database user to own the new EUL, use this field to enter a password for the new database user.
If you want an existing database user to own the new EUL, use this field to enter the password for that user.
Passwords are case-sensitive in Oracle databases (Enterprise Edition release 11.1 or later).
This field is grayed out if you have specified that the current user (that is, the username you used to start Discoverer Administration) will own the EUL.
If you want a new database user to own the new EUL, use this field to reenter the password for the new user.
This field is grayed out if you have specified that an existing user will own the new EUL.