User lock information

[newssis]

hi how can i know when and what time user was locked?

Please help!!

 

[karluk]

Try

select username, to_char(lock_date, 'dd-mm-yyyy.hh24:mi:ss') from dba_users
where username = 'TYPE USERNAME HERE';

 

[SantaMufasa]

Newssis,

If you ask for, and receive, an excellent reply to your inquiry, it is appropriate, at least, to respond to the poster who shares her/his time and resources to solve your need.

KarlUK posted an excellent resolution. He deserves from you [ul][li]a response that you tried his suggestion, [/li][li]your thanks, [/li][li]and a

.[/li][/ul]

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”