Re: Possible? Manually set EXPTIME in USER$ to set EXPIRY_DATE in DBA_USERS

Kai-Joachim Kamrath doodled thusly:

>I know that it's possible, though *highly* (and rightly) discouraged, to
>tamper with Oracle's underlying database definition tables (meta data),
>owned by SYS. But just maybe...

Hmmm, maybe. But not in this case, I'd think.

>passwords... yet Oracle gives me just one option to do so: ALTER USER
>username PASSWORD EXPIRE. This takes effect immediately. I'd prefer to
>give the users some warning, and allow them to warm up to the idea. I'd

I suppose one alternative would be to use a login trigger that checks if user's password is about to "expire" and warns the user accordingly?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sun Mar 31 2002 - 18:27:37 CST