Re: Password Verification Function Help

Mark Bole wrote:
> Anurag Varma wrote:
>
> > <kingkongbubdy4_at_yahoo.com> wrote in message
> > news:1108311434.711244.266470_at_g14g2000cwa.googlegroups.com...
> >
> >>Hi,
> >>
> >>I am relatively new to Oracle 9i and trying to (at this point)
create a
> >>password verification function for the DEFAULT profile that will
allow
> >>me to produce some output to the screen (if possible) when I change
a
> >>user password. I have....
> >>
> [...]
> >>Is it possible to get output to the screen through the
> >>PASSWORD_VERIFY_FUNCTION when a password is changed? If so, can
anyone
> >>point me in the right direction? If not, can the the equivalent
'Hello
> >>World' output be saved to a file instead of the screen?
> >>
> >>Thanks,
> >>kingkong
> >>
> >
> >
> > 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

If you cannot get to the dbms_output buffer e.g. as in above scenario plus using dbms_output in triggers etc... then dbms_pipe is another option.

Regards
/Rauf Received on Sun Feb 13 2005 - 18:22:13 CST