Subject Users & Roles
Author cbmrussn
FB 1.0.796

I'm attempting to add roles to my database, to base user default
types on. However, when I grant a role to a user, it appears to not
take effect, and the user doesn't have permission to the table that
the role has permission to.

Example.

Create Role BasicRole;
Grant Select on Customer to BasicRole;
Grant BasicRole to John;

When the user John is trying to access the table, the error
message, "No permission for Read/Select Access on TABLE CUSTOMER"
comes back. The Table's owner is SYSDBA,
and SYSDBA granted the access to the Role, and granted the role to
the user. From what I read in the interbase docs, and from searches
on this NG, this should work. However, it's not. Is there something
that I am missing here?