-- Check for both reuse max and reuse time not set

select profile  from DBA_PROFILES
where (resource_name='PASSWORD_REUSE_MAX'
       and limit in ('UNLIMITED','NULL'))
and profile in
       (select profile from DBA_PROFILES where
              resource_name='PASSWORD_REUSE_TIME')
      and limit in ('UNLIMITED','NULL');

-- Check for reuse max with value that is less than allowed minimum

select profile from DBA_PROFILES
  where resource_name='PASSWORD_REUSE_MAX'
  and limit not in ('UNLIMITED','NULL')
  and limit < '10';

-- Check for reuse time that is less than allowed minimum

select profile from DBA_PROFILES
  where resource_name='PASSWORD_REUSE_TIME'
  and limit not in ('UNLIMITED','NULL')
  and limit< '365';