grant select on SCOTT.* to vewalluser

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Tue, 31 Oct 2006 11:26:52 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F70C8D4529@irv2kexch01.tx.bg.corp>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 31 2006 - 11:26:52 CST