Re: Password Verification Function Help

"Mark Bole" <makbo_at_pacbell.net> wrote in message news:eWRPd.4697$aW6.763_at_newssvr22.news.prodigy.net...
> Anurag Varma wrote:

-snip-
> >
> > Too lazy to verify this myself...
> > However, make sure you *test* the verify function while logged
> > in as a non-sys user.
> > If I remember correctly, password verify function is not called when
> > logged in as SYS ... or the errors / output from the function is ignored
> > while logged in as SYS.
> >
> > Anurag
> >
> >
>
> I actually did test that, still didn't work. I believe the problem has
> to do with the well-known DBMS_OUTPUT limitations. The verify function,
> called as part of the profile enforcement process, writes its
> DBMS_OUTPUT to a buffer, but the client session (the one issuing "ALTER
> USER ... IDENTIFIED BY..." does not appear to have any way to get at
> that buffer.
>
> --
> Mark Bole
> http://www.bincomputing.com
>
>

Mark,

Yes .. after some test, I believe you are right. Its likely that the function is called in a separate session, so the dbms_output's output does not appear in the current session...

Anurag Received on Sun Feb 13 2005 - 20:44:27 CST