[kim]

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
begin
execute immediate ‘alter session set current_schema=apps’;
end;
/

create or replace function apps.kc_apps_validate_login(p_username in varchar2, p_password in varchar2) return varchar2 authid definer as
begin
return fnd_web_sec.validate_login(p_username,p_password);
end kc_apps_validate_login;
/

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

[Author]

Posts