Re: Oracle passwords - how do you handle this?

In article <1993Oct14.192823.8308_at_synapse.bms.com>, kaz_at_sis.bms.com writes:
|>
|>At our site, we have about 12 different instances of Oracle (with more
|>on the way). One thing that is becomming more of a problem is the number
|>of separate Oracle accounts that some users need, and maintaining the passwords
|>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
|>their password as required by application A, they don't really know that
|>this is the same account/password for applications C and D, but that
|>applications E and F still use thier old password because it's in a
|>different instance.
|>
|>My question is: How do others handle this? Is there some (fairly easy)
|>way to propogate a password change to other instances where the use has
|>an account? Do you just avoid using personal accounts for Oracle
|>applications?
|>
|>----------------
|>Joe Kazimierczyk
|>kaz_at_bms.com
|>
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 ?

-- 
------------------------------------------------------------------------------
   /_/_/_/_/    _/_/_/_/  /_/_/_/_/   _/_/_/_/                  I use
  /_/_/          _/_/       _/_/       _/_/               ORACLE v6.0.36.5.2
 /_/_/          _/_/       _/_/       _/_/                       on        
/_/_/_/_/ .  _/_/_/_/ .   _/_/ .   _/_/_/_/ .            DEC RISC ULTRIX v4.3
------------------------------------------------------------------------------
Yves NOEL   -   Database Administrator
C.I.T.I. (batiment M4)                             Phone : (33)  20.43.42.70
Universite des Sciences & Technologies de Lille    Fax   : (33)  20.43.66.25 
59655 Villeneuve d'Ascq Cedex - FRANCE             Email : noel_at_univ-lille1.fr
------------------------------------------------------------------------------