|Subject||RE: [firebird-support] Re: I can't get roles to work...|
>I never use this syntax!
> 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
> --- In firstname.lastname@example.org, Helen Borrie <helebor@...> wrote:
> > grant ROLE tooluser to BOBJOHN
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.
> > 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