Home » RDBMS Server » Security » last password change
last password change [message #300792] Mon, 18 February 2008 02:43 Go to next message
nani_ar
Messages: 58
Registered: March 2006
Member
Hi all,

How to know the date and time when a password has been changed for a user in oracle. Is there any tool or view to know it.

All the replies are welcome and thanks in advance..


Regards
nani
Re: last password change [message #300800 is a reply to message #300792] Mon, 18 February 2008 02:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYS.USER$.PTIME

Regards
Michel
Re: last password change [message #300806 is a reply to message #300800] Mon, 18 February 2008 02:59 Go to previous messageGo to next message
nani_ar
Messages: 58
Registered: March 2006
Member
Thanks Cadot.

Nani
Re: last password change [message #301786 is a reply to message #300800] Thu, 21 February 2008 13:29 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Michel Cadot wrote on Mon, 18 February 2008 01:48
SYS.USER$.PTIME

Regards
Michel




Thanks ;)Didn't know that.
Re: last password change [message #302582 is a reply to message #300792] Tue, 26 February 2008 04:13 Go to previous messageGo to next message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
Hi

I am connecting to SYS but where is this object?

-------------
SQL> desc SYS.USER$.PTIME
Usage: DESCRIBE [schema.]object[@db_link]
SQL>
SQL> desc USER$.PTIME
ERROR:
ORA-04043: object USER$.PTIME does not exist


Regards
Re: last password change [message #302585 is a reply to message #302582] Tue, 26 February 2008 04:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SYS=owner
USER$=table
PTIME=column

Standard notation.

Regards
Michel
Re: last password change [message #302594 is a reply to message #300792] Tue, 26 February 2008 04:49 Go to previous message
ORA-MAN
Messages: 24
Registered: January 2008
Location: ===
Junior Member
thanks Michel for your help as usual
Previous Topic: Could I use trigger to move 'EXPIRED' to 'LOCKED' ?
Next Topic: changing profile for multiple users
Goto Forum:
  


Current Time: Thu Mar 28 05:49:40 CDT 2024