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@...* <mailto:marvin@...>
*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]