Re: Grant table right

From: EdStevens <quetico_man_at_yahoo.com>
Date: Wed, 26 Dec 2007 08:09:34 -0800 (PST)
Message-ID: <772f3c4b-a30c-47a6-aed8-3b6d5c12337f@s19g2000prg.googlegroups.com>

On Dec 26, 7:39 am, l..._at_tech-trans.com wrote:
> Hi,
>
> I want to grant right to a Oracle user by using
> "grant insert,select,delete,update, on table1 to ABC" generally.
> However, the owner has more than 600 tables. How can I do?
>
> Ming

spool doit.sql
select 'grant insert, select, delete, update on XYZ.' ||

          table_name ||
          'to ABC;'

from dba_tables
where owner = 'XYZ';
spool off

take a look at doit.sql Received on Wed Dec 26 2007 - 10:09:34 CST