grant select on SCOTT.* to vewalluser

Hi List,
Is there a simple way to do this besides the following?
set echo off;

set heading off;

set feedback off;

set pagesize 0;

spool grant.sql;

select 'grant select on ' table_name ' to viewalluser' from user_tables;

spool off;

set feedback on;

set heading on;

set echo on;

@grant.sql;
Thanks,
Roger


This e-mail is intended solely for the person or entity to which it is 
addressed and may contain confidential and/or privileged information. Any 
review, dissemination, copying, printing or other use o
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email Security 
System.

Other related posts: