As you said Alexandre, it´s not what I was expecting to hear but thank you
for your suggestions.

What about user PEPE creating tables. Is there a way to avoid this?

Gustavo

----- Original Message -----
From: "Adam" <s3057043@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, October 29, 2007 8:26 PM
Subject: [firebird-support] Re: Read only user


>>
>> 2.) if you use FB 2.0
>> execute block as
>>
>> declare variable wTableName varchar(30);
>> declare variable wstm varchar(255);
>>
>> begin
>> for
>> select
>> r.rdb$relation_name
>> from
>> rdb$relations r
>> where
>> rdb$view_blr is null and
>> rdb$system_flag = 0
>> into :wTableName
>> do begin
>> wstm = 'grant select on ' || wTableName || ' to PEPE;';
>> execute statement wstm;
>> end
>>
>> end;
>>
>
> Clever.
>
> However to the OP, I strongly recommend that you never grant rights
> directly to a user. Instead, create a role called ReadOnlyUser and
> grant the permissions to select to that role. Then grant ReadOnlyUser
> to PEPE (and whoever else needs it).
>
> PEPE can then connect with that role.
>
> Adam
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
> __________ Información de NOD32, revisión 2625 (20071030) __________
>
> Este mensaje ha sido analizado con NOD32 antivirus system
> http://www.nod32.com
>
>