View privileges granted to an user - oracle database script

-- System privileges granted to an user ( scott)  
SELECT * FROM DBA_SYS_PRIVS where grantee='SCOTT';  
-- Roles granted to an user ( scott)  
SELECT * FROM DBA_ROLE_PRIVS where grantee='SCOTT';  
-- Object privileges granted to an user ( SCOTT)  
SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE='SCOTT';  
-- Column specific privileges granted  
SELECT * FROM DBA_COL_PRIVS WHERE WHERE GRANTEE='SCOTT';