Thank you very much!!!
It works great!!

--- In firebird-support@yahoogroups.com, Marcos Vinicius Dufloth
<marvin@t...> wrote:

>
> Run this query:
>
> select 'grant all on ' || rdb$relation_name || ' to guest;' from
> rdb$relations where rdb$system_flag = 0;
>
> and run the result rows as a script.
> --
>
> *__________________________________________________________________*
> *Marcos Vinicius Dufloth*
> *Diretor de Tecnologia
> **Cyber Informática Empresarial**
>
> marvin@c...* <mailto:marvin@c...>
> *http://www.tecnocyber.com.br* <http://www.tecnocyber.com.br/>
> *__________________________________________________________________
>
> *
>
>
> Martijn Tonies wrote:
>
> >Hi Alberto,
> >
> >
> >
> >
> >>I need to grant select to all tables to a user named guest but I

have

> >>near 200 tables...
> >>How can I do this??
> >>
> >>
> >
> >By using a GUI tool like Database Workbench ( www.upscene.com )
> >and starting the Grant Manager. Click in the top left corner and

select

> >"Grant all". Then press "Save grants".
> >
> >
> >With regards,
> >
> >Martijn Tonies
> >Database Workbench - developer tool for InterBase, Firebird & MS

SQL Server.

> >Upscene Productions
> >http://www.upscene.com
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

> >
> >
> >
> >
> >
> >
>
>
>
>
> [Non-text portions of this message have been removed]