Limit the search to those users who changed their password today:
select name,ctime "created", ptime "passw change time",ltime "last locked", lcount "# failed logins" from user$ where trunc(ptime) = trunc(sysdate) order by 3 desc;
Example output:
NAME | created | passw change time | last locked | # failed logins |
---|---|---|---|---|
JIM | 25.11.2016 02:25:38 | 12.12.2016 09:59:25 | 0 | |
JOHN | 25.11.2016 02:25:55 | 12.12.2016 09:53:19 | 0 | |
JAMES | 25.11.2016 02:25:54 | 12.12.2016 09:29:50 | 0 |
No comments:
Post a Comment