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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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: problem audit in oracle9i
Goto Forum:
  


Current Time: Sun Dec 22 01:22:26 CST 2024