Number of accounts with passwords that have never been changed

select count(*) from sys.user$
where user# in (select user_id from dba_users
where account_status = ‘OPEN’)
and (
(ptime is null)
or
(ptime is not null
and ptime <= ctime)
);

  • January 3, 2018 | 20 views
  • Comments