oracle权限查询

获得系统相关权限

select * from  dba_sys_privs a where a.GRANTEE = 'UAPP';

/*
-- Grant/Revoke system privileges
grant execute any procedure to UAPP;
grant select any dictionary to UAPP;
grant select any table to UAPP;
grant unlimited tablespace to UAPP;
*/

---

获得 角色 相关权限

select * from  dba_role_privs a where GRANTEE = 'UAPP';

/*
-- Grant/Revoke role privileges
grant dba to UAPP;
grant resource to UAPP;
grant select_catalog_role to UAPP;
*/

---

获得表相关权限

select * from  DBA_TAB_PRIVS a where GRANTEE = 'UAPP';

/*
grant execute on SYS.DBMS_LOCK to UAPP;
grant execute on UDATA.FUNCTION_GETSEQ to UAPP;
grant execute on UDATA.PROCEDURE_DEALSEQ to UAPP;
grant insert, update on UDATA.TL_MAIL to UAPP;
*/