Actually there are exactly two things in the database: the test_table
and the tooluser role. I even dropped and rebuilt the database and
reinstalled the security database -- still no luck...

Mike...

--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> 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