How to check last password change date in Oracle?
set linesize 200
set pagesize 200
col Last_Password_Change_Time format a30
select
user#,
name,
ctime as Creation_Time,
--to_char(ctime,'DD-MON-YY HH:MI') as Creation_Time,
to_char(ptime,'DD-MON-YY HH:MI') as Last_Password_Change_Time
from
SYS.USER$
where
ctime is not null
and
name not in (select role from dba_roles)
order by ptime;
 |
No comments:
Post a Comment