oracle查看用户有哪些权限和角色

select * from dba_sys_privs t where t.grantee='HR';
select * from dba_role_privs t where t.grantee='HR';

posted @ 2016-02-27 17:25  ppjj  阅读(720)  评论(0)    收藏  举报