Home » RDBMS Server » Security » database password changes (merged)
database password changes (merged) [message #405298] Wed, 27 May 2009 05:54 Go to next message
Atomicoman
Messages: 1
Registered: May 2009
Junior Member
how can i enforce users to password password changes after a set ammount of logins or time has past.
Re: database password changes [message #405308 is a reply to message #405298] Wed, 27 May 2009 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 28991
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Have a loop at profiles.

Regards
Michel
Re: database password changes [message #405311 is a reply to message #405298] Wed, 27 May 2009 06:10 Go to previous message
JRowbottom
Messages: 5254
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
A PROFILE will let you specify a password life.

To force password change after a certain number of logins, you'd need an on-logon trigger that updated a count of logins held in a table somewhere.

[Fix unexpected format changes]

[Updated on: Wed, 27 May 2009 06:14]

Previous Topic:PRIVILEGES
Next Topic:AUDIT tracking for ROLLBACK and COMMIT
Goto Forum:
  


Current Time: Sun Nov 8 17:52:15 CST 2009

Total time taken to generate the page: 0.22030 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.