set echo off
set heading off
set pagesize 500
spool e:\grantright.sql;
select 'grant select,inset,delete,update on '||table_name||' to userB' from user_tables;
spool off;
@e:\grantright.sql;
/
set heading off
set pagesize 500
spool e:\grantright.sql;
select 'grant select,inset,delete,update on '||table_name||' to userB' from user_tables;
spool off;
@e:\grantright.sql;
/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货