Check which user has 'ALTER SESSION' and 'ALTER SYSTEM' privileges

select grantee from dba_sys_privs where privilege = 'ALTER SESSION';


select grantee from dba_sys_privs where privilege = 'ALTER SYSTEM';