select privilege from dba_SYS_privs where grantee=‘USERNAME’;
使用user_sys_privs!
select * from dba_sys_privs where grantee='SCOTT';
USER_TAB_PRIVS_RECD