- May 4, 2017 at 13:09 #3204kimKeymaster
When testing on a non-production database you can probably use the APPS database user for the connection.
When connecting to a production database you should create a “read-only” database user. The following script can be executed by the DBA and will create such a user. The script will create a user called apps_query.
create user apps_query identified by apps_query;
create or replace trigger apps.apps_query_logon_trg
after logon on apps_query.schema
execute immediate ‘alter session set current_schema=apps’;
create or replace function apps.kc_apps_validate_login(p_username in varchar2, p_password in varchar2) return varchar2 authid definer as
grant connect to apps_query;
grant select any table to apps_query;
grant execute on apps.kc_apps_validate_login to apps_query;
–grant execute on apps.xxen_api to apps_query;
The last statement which is commented out is only necessary if you have Blitz Reports installed
- The topic ‘Creation of Oracle DB User’ is closed to new replies.