oracle 给用户批量授权unlimite tablespace


select 'grant unlimited tablespace to '|| r.GRANTEE ||';'  from dba_sys_privs r,dba_users u where grantee not in(
select distinct grantee from dba_sys_privs where privilege='UNLIMITED TABLESPACE'
) and u.username = r.GRANTEE AND user_id > 54
group by r.GRANTEE;

--仅支持oracle 10g
请使用浏览器的分享功能分享到微信等