Access to reports developers?

[sikandar]

What is the best way to give access of database to reports developers?

[Atif]

The two approaches that i have so far experienced are
1)Give access to the relevant schema only
2) Give access of Apps schema

First one is good for data security reasons
Second is good for cross module integration reports.I preferred this one
Atif

[admin]

Thanks for the reply. I have created a SR so let see what will be the Oracle response so will share here when I will get any. Thanks

[admin]

Here is the Oracle response but still working with them. It is not for WINDOWS.

We usually use APPS user to connect to Oracle Applications Database to create customer reports from Oracle Reports.

You should be able to create custom user with all privileges like APPS as follows.

1. From the database home please connect to the database using sqlplus as sysdba.
Issue the following command:

Create user <APPS1_USERNAME> identified by <PASSWORD>

Please replace :

<APPS1_USERNAME> with new user which will be used to connect from ORacle Reports, e.g SIKANDAR1
<PASSWORD> password for user <APPS1_USERNAME>

2. If you don't have directory $ORACLE_HOME/appsutil/admin in the 9.2.0 directory on the database tier please create it. (You should have "appsuti
l", but "admin" directory may not exist)

3. Copy script adgrants.sql (UNIX) from $APPL_TOP/admin to $ORACLE_HOME/appsutil/admin.

4. Run the script from the ORACLE_HOME/appsutil/admin: adgrants.sql (( with your new APPS-USER))

sqlplus '/ as sysdba' @adgrants.sql <APPS1_USERNAME>

Where : <APPS1_USERNAME> is user created in step 1.

5. Try to connect to Oracle Database from Oracle Reports using this user.