which dictionary view will show all the privileges assigned to an oracle user?

Select LPAD (' ', 2 * Level)
|| granted_role "user, his roles and privileges"
From ( /* the users */Select Null grantee, username granted_role
From dba_users
Where username Like
UPPER
('%&enter_username%')
/* the roles to roles relations */
Union
Select grantee, granted_role
From dba_role_privs
/* the roles to privilege relations */
Union
Select grantee, Privilege
From dba_sys_privs)
Start With grantee Is Null
Connect By grantee = Prior granted_role;

__________________
Sireesha