Are you especifing role name in connection?

Dufloth.


cbmrussn wrote:

>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?
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>