Home » RDBMS Server » Server Administration » ORACLE DATABASE (Oracle 10, 10.2.0, HP-unix)
ORACLE DATABASE [message #394508] Fri, 27 March 2009 09:20 Go to next message
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
Re: ORACLE DATABASE [message #394513 is a reply to message #394508] Fri, 27 March 2009 09:41 Go to previous message
Mahesh Rajendran
Messages: 10672
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

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:
  


Current Time: Wed Dec 07 12:50:52 CST 2016

Total time taken to generate the page: 0.17300 seconds