CODE EXAMPLE FOR SQL

oracle privileges users

SELECT USERNAME,
       LOCK_DATE,
       EXPIRY_DATE
FROM DBA_USERS
WHERE USERNAME IN (SELECT GRANTEE
                   FROM DBA_SYS_PRIVS
                   WHERE PRIVILEGE = 'UNLIMITED TABLESPACE')
ORDER BY USERNAME;