Oldest Password Change Time

select min(ptime) from sys.user$
where user# in (select user_id from dba_users
where account_status = ‘OPEN’)
and ptime is not null
and ptime > ctime;
  • January 3, 2018 | 13 views
  • Comments