Subject Re: How to create an user and grant him select to all the table in the database ?
Author karolbieniaszewski
--- In firebird-support@yahoogroups.com, Vander Clock Stephane <svanderclock@...> wrote:
>
> Hello,
>
> how to create an user and grant him only select right to all the table
> in the database ?
>
> thanks by advance
> stéphane
>

Hi,

do somethink like
for select RDB$RELATION_NAME from RDB$RELATIONS
into ...

do

execute statement "here grant privilege"


in procedure or execute block

Karol Bieniaszewski