Creating an EUL
i) When you have clicked Yes to the EUL creation prompt message, the following dialog will be displayed.
ii) Click on the button create an EUL then from the dialog box (shown below) click on select button to select the user.
iii) Click on the Select button to select the user. We will select the EUL_OWNER user to save the EUL data into this user.
iv) When the user is selected, click on the Finish button.
v) Wait until the below screen appears.
vi) Click No button when the below message appears because we do not need to load sample data. We will create our own business area.
vii) Close the EUL Manager window by pressing the close button.
Log-in with BI Administrator.
i) Select Start > Programs > Oracle Business Intelligence Tools – (BI Home Name) > Oracle Discoverer Administrator. The Connect to Oracle Business Intelligence Discoverer Administrator dialog box appears.
ii) Enter the username, password and connect string to Log in.
iii) When you will click the connect button, the following message will be displayed. Just click Yes and what to do next will be discussed in next post.
Creating Discoverer Admin user.
Note: It is not necessary but It is recommended that a separate Admin user should be created in which the EUL (End User Layers) will be generated and all the data will be maintained. We will create a user named “EUL_OWNER”.
i) Login with “system” user on your database.
ii) Create user EUL_OWNER.
iii) Grant the following privilidges to the EUL_OWNER.
SQL> Grant Connect, Resource to EUL_OWNER;
SQL> Grant Global Query Rewrite to EUL_OWNER;
SQL> Grant Select Any Table to EUL_OWNER;
SQL> Grant Create Any Materialized View to EUL_OWNER;
SQL> Grant Alter Any Materialized View to EUL_OWNER;
SQL> Grant Drop Any Materialized View to EUL_OWNER;
————————————
OPTIONAL PRIVILIDGES
————————————
SQL> Grant Create Any Table to EUL_OWNER;
SQL> Grant Create Any View to EUL_OWNER;
SQL> Grant Create Any Procedure to EUL_OWNER;
SQL> Grant Create Any Sequence to EUL_OWNER;
SQL> Grant Create Any Synonym to EUL_OWNER;
