Access to reports developers?
Access to reports developers?
What is the best way to give access of database to reports developers?
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.
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.
Who is online
Users browsing this forum: No registered users and 1 guest