How to find User / Schema privileges of user in Oracle

select * from dba_role_privs where grantee = 'USERNAME';

SELECT * FROM USER_ROLE_PRIVS WHERE GRANTED_ROLE != 'CONNECT'; -- Roles of the actual Oracle Schema

select * from USER_ROLE_PRIVS where USERNAME='USERNAME';

select * from USER_TAB_PRIVS where Grantee = ' USERNAME ';

select * from USER_SYS_PRIVS where USERNAME = ' USERNAME ';

This query will show grant privileges for your schema

SELECT PRIVILEGE

FROM sys.dba_sys_privs

WHERE grantee = ' USERNAME '

UNION

SELECT PRIVILEGE 

FROM dba_role_privs rp JOIN role_sys_privs rsp ON (rp.granted_role = rsp.role)

WHERE rp.grantee = ' USERNAME '

ORDER BY 1;