使用SQL生成SQL

set echo off heading off feedback off

spool sql.txt

select 'grant connect,resource to '||username||';'  from dba_users;

spool off

@sql.txt