In addition to VAV’s answer, The first one was most useful in my environment
select * from USER_ROLE_PRIVS where USERNAME='SAMPLE';
select * from USER_TAB_PRIVS where Grantee="SAMPLE";
select * from USER_SYS_PRIVS where USERNAME = 'SAMPLE';
In addition to VAV’s answer, The first one was most useful in my environment
select * from USER_ROLE_PRIVS where USERNAME='SAMPLE';
select * from USER_TAB_PRIVS where Grantee="SAMPLE";
select * from USER_SYS_PRIVS where USERNAME = 'SAMPLE';