Subject | Users & Roles |
---|---|
Author | cbmrussn |
Post date | 2002-06-07T17:56:07Z |
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?
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?