Re: "grant select" for all tables: Is it possible?

"Dave" <x_at_x.com> wrote in news:LDHKe.86705$G8.71004 @text.news.blueyonder.co.uk:

> begin
> for i in (select table_name from tabs) LOOP
> execute immediate 'grant select on '||i.table_name||' to user2';
> end loop;
> end;
> /

Thanks a lot, that's easy and will certainly prove useful!

Best regards
W. Rösler Received on Fri Aug 12 2005 - 02:46:33 CDT