select privilege from dba_sys_privs where grantee='SCHEMA_NAME' order by 1;
we have to use
USER_TAB_PRIVS_RECD USER_COL_PRIVS_RECD