Subject | Re: [firebird-support] GRANT ALL TO PUBLIC |
---|---|
Author | Svein Erling Tysvaer |
Post date | 2006-06-13T07:35:24Z |
Well, this list ain't for Firebird 2 questions yet, but I can answer
from a Firebird 1.5 perspective.
robertgilland wrote:
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
from a Firebird 1.5 perspective.
robertgilland wrote:
> I tried to do this and got the below error.In my opinion, that's a sensible answer. You haven't specified what you
> 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
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