Re: Log user account lockouts

From: gazzag <gareth_at_jamms.org>
Date: 16 Mar 2006 08:39:37 -0800
Message-ID: <1142527177.748019.110160@p10g2000cwp.googlegroups.com>

mikaelkruse wrote:
> also dba_users only provide date, no time.

Not true. In Oracle, the DATE datatype also holds the time. You just have to know how to view is:

  1 select to_char(lock_date, 'DD-Mon-YY HH24:MI:SS')   2 from dba_users
  3* where username = 'DEMO'
SQL> / TO_CHAR(LOCK_DATE,

---

16-Mar-06 16:37:13

HTH -g Received on Thu Mar 16 2006 - 10:39:37 CST