I know, in MySQL there is a possibility to grant all on *.*, which means to
grant all privileges to public on every table, view, etc.
And I know, there isn't a possibility in FB1.5.

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>
To: "Firebird-support" <firebird-support@yahoogroups.com>
Sent: Tuesday, June 13, 2006 9:35 AM
Subject: Re: [firebird-support] GRANT ALL TO PUBLIC


> Well, this list ain't for Firebird 2 questions yet, but I can answer
> from a Firebird 1.5 perspective.
>
> robertgilland wrote:
>> I tried to do this and got the below error.
>> Is there an easy way to do this?
>>
>> Regards,
>>
>> Robert
>>
>> Using Firebird 2 Classic
>>
>> ISC ERROR CODE:335544569
>>
>> ISC ERROR MESSAGE:
>> Dynamic SQL Error
>> SQL error code = -104
>> Token unknown - line 1, column 11
>> TO
>
> In my opinion, that's a sensible answer. You haven't specified what you
> are granting to public. The syntax should be
>
> GRANT ALL ON <tablename, view etc.> TO PUBLIC
>
> I may be wrong, but I've never heard of a way to grant anything on
> everything to everybody.
>
> HTH,
> Set
>