Get all the Privileges and Roles Granted to an Oracle User

It is often required to review all the privileges/roles assigned to an Oracle user. Below piece of SQL can be run via SQL developer or SQLPlus to get this information, just replace username below and it's done.

define usern = 'USERNAME'

Select 'SYS Privs> ' || privilege as privilege from dba_sys_privs where grantee='&&usern'
union
Select 'OBJ Privs> ' || privilege || ' on ' || owner || '.' || table_name from dba_tab_privs where grantee='&&usern' --and grantor<>'SYS'
union
Select 'Roles> ' || granted_role from dba_role_privs where grantee='&&usern'
union
Select 'COL Privs> ' || privilege from dba_col_privs where grantee='&&usern'
Order by 1;

Cheers!
Anurag