Create EUL Wizard dialog

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:

"What is an End User Layer?"

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

User

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.

Select

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.

Password

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.

Confirm password

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.