Re: Calculated passwords ?

Yeah, I'm a bit confused, too. It sounds as though your system will be consistently changing the passwords at whatever interval you think appropriate and then checking them at connect time. Like Daniel, I don't

believe that there's a way to extract the password so that it can be used by a chunk of "plain", user-written PL/SQL code.

If you're open to a design change, however, you may want to consider the use of a "PASSWORD_VERIFY_FUNCTION" in the user's or the system profile. Read all about it in chapter 21 of the "Oracle8i Administrator's Guide, Release 2 (8.1.6)", Oracle part number A76956-01, or in the latest Oracle9i version of the doc.

If you take this path, be sure to heed this nugget:

Oracle recommends that you do not change passwords using the ALTER USER statement because it does not fully support the password verification function.
Instead, you should use OCIPasswordChange() to change passwords.

Bye,
Tom

Andreas Koch wrote:

> Daniel Morgan wrote:
>
> > No of which I am aware.
> >
> > But you could accomplish the same thing by giving everyone the same
> > password and having authentication done by a LOGON system trigger.
>
> How would the "custom" password be passed to that trigger?
>
> --
> Andreas
> To boldly go where no sane person has gone before
Received on Tue Aug 13 2002 - 18:23:41 CDT