Viewing 1 post (of 1 total)
  • Author
    Posts
  • #3204
    kim
    Keymaster

    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

    • This topic was modified 3 years ago by kim.
    • This topic was modified 3 years ago by kim.
Viewing 1 post (of 1 total)
  • The topic ‘Creation of Oracle DB User’ is closed to new replies.