- AuthorPosts
- 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
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
- AuthorPosts
- The topic ‘Creation of Oracle DB User’ is closed to new replies.