Re: Changing Oracle Password

In <3q55ps$5ru_at_tbsnames.turner.com> Tony Rodgers <trodgers> writes:
>
>Oracle currently does not have a function to "expire" passwords.
 There may be
>some third-party products out there which will do what you need,
 especially
>security packages. And, it might be possible to write your own
 scripts to
>periodically go through the dba_users table and check for a time
 (which would
>have to be kept in a separate table) of expiration. Then, you could
 blow away
>the user's password if the time has expired. It would be nice if you
 could
>sent the user a warning, but I'm not sure how you would handle that.
>

I've never tried it myself, but couldn't you use ALTER USER xxx IDENTIFIED EXTERNALLY and let the operating system handle the password managment?

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!