Jay S wrote:
> 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;
wrbsrv.app, if memory serves well (3.0 is OLD, you know)
You can use the admin pages to set it up.
--
Regards, Frank van Bortel
Received on Fri Oct 03 2003 - 04:05:22 CDT
