That's what we did where I work. We made modifications (additions) to the $ORACLE_HOME/rdbms/admin/utlpwdmg.sql script provided by Oracle. On 11/9/06, rjamya <rjamya@xxxxxxxxx> wrote:
you can set-up a profile which will let you call a user written function. Within that function you can check sys.user$.ptime and then put the restriction. Raj On 11/9/06, Michael Chan <mphchan23@xxxxxxxxx> wrote: > Hi All, > > I'm being asked by my security officer that if I can put in control such > that a database user can only change password once a day. i.e. the minimum > life time of a password should be 1. > > Any suggestions/recommendations ? -- //www.freelists.org/webpage/oracle-l