给一个用下的所有表赋权给另一个用户.sql

set heading off;
set feedback off;
spool "GRNAT_TO_HSCDIFF_PRIVALE.SQL";
select 'grant select,delete,update,insert on '||table_name||' to  hscdiff;' from user_tables;
spool off; 
set heading on;
set feedback on;
spool 'GRNAT_TO_HSCDIFF_PRIVALE.LOG';
@GRNAT_TO_HSCDIFF_PRIVALE.SQL;
spool off;
exit;