oracle查看用户的系统权限，角色以及数据库对象权限

select * from dba_sys_privs where GRANTEE='monkey';

select * from dba_role_privs where GRANTEE='monkey';

select * from DBA_TAB_PRIVS where GRANTEE='monkey';