OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORACLE DATABASE (Oracle 10, 10.2.0, HP-unix)

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

ORACLE DATABASE [message #394508]

Fri, 27 March 2009 09:20

tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi

Senior Member

Hi,

actually someone has reset the password of user.

can i know the date of resetting the password.

thanks

Regards
Tarun Mittal

Report message to a moderator

Re: ORACLE DATABASE [message #394513 is a reply to message #394508]

Fri, 27 March 2009 09:41

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

  1* select name,ctime,ptime from  sys.user$ where name='SCOTT'
dbadmin@chum > /

NAME			       CTIME		    PTIME
------------------------------ -------------------- --------------------
SCOTT			       09-Nov-2007 01:09:05 30-Jan-2009 11:44:33

dbadmin@chum > alter user scott identified by tiger;

User altered.

dbadmin@chum > select name,ctime,ptime from  sys.user$ where name='SCOTT';

NAME			       CTIME		    PTIME
------------------------------ -------------------- --------------------
SCOTT			       09-Nov-2007 01:09:05 27-Mar-2009 10:21:58

Report message to a moderator

Previous Topic:	ORA-00376: file 201 cannot be read at this time
Next Topic:	How to bring up database automatically on Solaris10 when rebooting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 17:39:58 CST 2024