Query the date when password has changed?

  • From: "Mark Moynahan" <mark.moynahan@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 29 Nov 2005 13:43:28 -0700

> OS: RHES 4
> DB: 10g R2
> 
> We have setup multiple profiles for different users. All but one
> profile is setup with expiration dates. The one profile that does not
> have an expiration date is used for application servers. Since the
> application accounts are mission critical the business does not want
> the password to expire. My dilemma is that I'm trying to determine
> when a users password has NOT changed in the past 30 days. Is there a
> way to query when the last time the password was changed.?
> 
> Thanks,
> 
> Mark
> 

Other related posts: