set feedback off
set heading off
set linesize 1000
set pagesize 0
set pause off
set trimspool on
set verify off
spool grant.sql;
select 'grant select on '||owner||'."'||tablename||'" to user1;'
from user_tables
where tablename like 'table%'
spool off;
set heading off
set linesize 1000
set pagesize 0
set pause off
set trimspool on
set verify off
spool grant.sql;
select 'grant select on '||owner||'."'||tablename||'" to user1;'
from user_tables
where tablename like 'table%'
spool off;
set feedback off
set heading off
set linesize 1000
set pagesize 0
set pause off
set trimspool on
set verify off
这是设置一些参数吧?
select 'grant select on '||owner||'."'||tablename||'" to user1;'
from user_tables
where tablename like 'table%'
spool off;
这个是赋select权限的吧?通过
select 'grant select on '||owner||'."'||tablename||'" to user1;'
from user_tables
where tablename like 'table%'
这条语句生成的grant语句在什么时候会执行啊?spool.off的时候执行么?