RE: Query the date when password has changed?
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <mark.moynahan@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 29 Nov 2005 13:49:20 -0700
I use:
select name, pdate
from sys.user$
where trunc(pdate) < trunc(sysdate) - 30;
For 9.2.0.x. It should work for 10.2, but I have not looked at this
yet.
--
Ron Reidy
Lead DBA
Array BioPharma, Inc
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mark Moynahan
Sent: Tuesday, November 29, 2005 1:43 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Query the date when password has changed?
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
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
Other related posts:
