| Subject | Re: [ib-support] Users & Roles |
|---|---|
| Author | Doug Chamberlin |
| Post date | 2002-06-07T19:27:20Z |
At 06/07/2002 01:56 PM (Friday), cbmrussn wrote:
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.
>Create Role BasicRole;I ran into this once. I believe the proper syntax is
>Grant Select on Customer to BasicRole;
>Grant BasicRole to John;
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.