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: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
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: 5933
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]

Report message to a moderator

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


Current Time: Sat Apr 19 12:39:50 CDT 2014

Total time taken to generate the page: 0.09228 seconds