CHECK the PRIVILEGES of a particular SCHEMA using VIEWS and SELECT

CHECK the PRIVILEGES of a particular SCHEMA using  VIEWS and SELECTALL_COL_PRIVS



ALL_COL_PRIVS_MADE
ALL_COL_PRIVS_RECD
ALL_REPGROUP_PRIVILEGES
ALL_TAB_PRIVS
ALL_TAB_PRIVS_MADE
ALL_TAB_PRIVS_RECD


USER_AQ_AGENT_PRIVS
USER_COL_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS_RECD
USER_REPGROUP_PRIVILEGES



USER_ROLE_PRIVS
USER_SYS_PRIVS
USER_TAB_PRIVS
USER_TAB_PRIVS_MADE
USER_TAB_PRIVS_RECD


NOTE:
Before running these queries you have login into the particular user

set heading off
set pages 0
set long 9999999
select dbms_metadata.get_granted_ddl('ROLE_GRANT', user)  from dual;
select dbms_metadata.get_granted_ddl('SYSTEM_GRANT', user)  from dual;
select dbms_metadata.get_granted_ddl('OBJECT_GRANT', user)  from dual;