Subject Re: Users & Roles
Author cbmrussn
Thanks for your quick responses. However, even with this, and Ivan's
advice, I'm still not having luck in getting the permissions to
work. I granted the role using the syntax you suggested, and I
specified the role while logging in. Still no access.

--- In ib-support@y..., Doug Chamberlin <DChamberlin@A...> wrote:
> At 06/07/2002 01:56 PM (Friday), cbmrussn wrote:
> >Create Role BasicRole;
> >Grant Select on Customer to BasicRole;
> >Grant BasicRole to John;
> I ran into this once. I believe the proper syntax is
> Grant BasicRole to User John;
> If you do not specify the "user" part then the database thinks the
grant is
> going to a procedure or something.