3,491
社区成员
发帖
与我相关
我的任务
分享
set heading off;
set echo off;
set pagesize 0;
set feedback off;
spool d:\b.sql
select 'grant all on '||OBJECT_NAME||' to 用户名;'
from user_objects
where OBJECT_TYPE in('TABLE','VIEW','SEQUENCE','SYNONYM','FUNCTION');
spool off;
@d:\b.sql