OAS 3.0 & owa_custom.authorize

From: Jay S <jayms_at_aol.com>
Date: 2 Oct 2003 13:34:35 -0700
Message-ID: <71a5cc99.0310021234.68ae230d@posting.google.com>

Oracle 8.1.7 on Win2k, OAS 3.0, using the PL/SQL gateway. There is an option to set up custom authentication using owa_custom.authorize, which I have done. The DAD appears to be accessing this procedure, when I go to a web page it pops up & asks for a username & password, but the procedure isn't getting the username/pwd combo- they appear to be null. (I have tried a lot of variations on this procedure.)

The documentation mentions "Custom authentication needs a static username/password to be stored in a configuration file, and cannot be combined with the dynamic username/password authentication. "

There is no information as to what or where this configuration file is.

Here is the code I am using. You will see a few different things commented or not, I have tried many combinations.

create or replace package body owa_custom as function authorize return boolean as

v_init          varchar2(25);
c_pwd           varchar2(25);
v_pwd           varchar2(25);
db_found        boolean;

begin

    db_found := true;
    owa_sec.set_protection_realm('REPORT');

    v_init := 'ABC'; --v_init := owa_sec.get_user_id;
    c_pwd := 'abc';--
    c_pwd := owa_sec.get_password;


--    begin

--        select password into v_pwd from user_list where init =

'ABC'; -- was v_init
-- exception

• when no_data_found then
• dbg_msg := 'no data found';
• db_found := true;
• end; if db_found then if c_pwd = v_pwd then return true; else return false; end if; else return false; end if; end authorize; end owa_custom;

Received on Thu Oct 02 2003 - 15:34:35 CDT