OraFAQ Forum: Security » last password change

Home » RDBMS Server » Security » last password change

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

last password change [message #300792]

Mon, 18 February 2008 02:43

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

Report message to a moderator

Re: last password change [message #300800 is a reply to message #300792]

Mon, 18 February 2008 02:48

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SYS.USER$.PTIME

Regards
Michel

Report message to a moderator

Re: last password change [message #300806 is a reply to message #300800]

Mon, 18 February 2008 02:59

nani_ar
Messages: 58
Registered: March 2006

Member

Thanks Cadot.

Nani

Report message to a moderator

Re: last password change [message #301786 is a reply to message #300800]

Thu, 21 February 2008 13:29

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.

Report message to a moderator

Re: last password change [message #302582 is a reply to message #300792]

Tue, 26 February 2008 04:13

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

Report message to a moderator