TQ 试用 WP

set pages 999;
set heading off;
spool d:\run_grant.sql
select 'grant select on '||owner||'.'||object_name|| ' to user1;'
from dba_objects
 where object_type='TABLE'  and owner='SCOTT';
spool off;