How to query Oracle's users that changed their password recently...
How to query Oracle's users that changed their password recently...
select name, ptime
           from sys.user$
           where exists (select username
                         from dba_users
                         where dba_users.username = user$.name
                         and
                         default_tablespace = 'your-user-tablespace')
    order by 1;