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;