>
> Hmmm..... When I attempt that command all I get is the error:
>
> Statement failed, SQLCODE = -104
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 1, column 12
> -tooluser
>
> --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
> >
> > grant ROLE tooluser to BOBJOHN

I never use this syntax!

CREATE ROLE ROLENAME;
GRANT ALL ON TABLENAME TO ROLENAME;
GRANT ROLENAME TO USERNAME;

if this is not doing as you ssupect, then I suspectc you already have
another object in your schema with a rolename or username.
Alan

> >
> > The table will happily store "rubbish" like GRANT TOOLUSER TO BOBJOHN
> > but of course, because it *is* rubbish, it doesn't have any entries
> in the ACL.
> >
> > ./hb
> >