Re: Oracle passwords - how do you handle this?

In article <29lohv$fv1_at_netserver.univ-lille1.fr> noel_at_univ-lille1.fr writes:
>
>In article <1993Oct14.192823.8308_at_synapse.bms.com>, kaz_at_sis.bms.com writes:
>|>

 [...]
>|>for these accounts. Since Oracle itsself doesn't have any method of
>|>password expiration, some of our inhouse applications now implement a
>|>method of doing this, and forcing the user to reset their password
>|>after x number of days. The problem here is that if someone changes
 [...]
>In fact there's an EXPIRES field in sys.dba_users table which signification is
>'Password expiration date' but after reading the DBA guide in all ways I've
>never found how to use this field ! Perhaps somebody has an idea ?

The Expires field is not used, it was added in anticipation that in a future version it would access it. I've checked with support and thier story is that it should be safe to usr that field to implement your own expiration date. But of course that would be "UNSUPPORTED".

yea right.

-- 
Regards, 

Lee E. Parsons                  		Baker Hughes Inteq, Inc
Oracle Database Administrator 			lparsons_at_exlog.com