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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-750762/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-750762/