[firebird-support] Re: How to create an user and grant him select to all the table in the database ?

Fri, 18 Nov 2011 01:41:32 -0800 


--- In [email protected], 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

Reply via email to