Subject Re: [ib-support] Users & Roles
Author Doug Chamberlin
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.