Subject Re: [firebird-support] GRANT ALL TO PUBLIC
Author Svein Erling Tysvaer
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