Hi

Thanks for the comments.

Yes, I am giving the role to the user, at the time of login.

--- In firebird-support@yahoogroups.com, <mark@...> wrote:
>
> On Mon, 29 Aug 2011 07:27:58 -0000, "vijeshv.nair"
> <vijeshv.nair@...> wrote:
> > Firbird + 1.5 Issue with User and Role
> >
> > Hi,
> > I am using firebird 1.5 and I have a user and a role. I gave execute
> > permission to Role and not user.
> > when I am trying to execute by logined by the user and gave the role, I
> am
> > getting the following error.
> >
> > Statement #1:
> > no permission for execute access to PROCEDURE SPSELECTMANAGERS.
> >
> > I checked the roles and users, The user is already added in the Roles.
> >
> > Hope you guys can Help me.
>
> Did you specify the role at login? The rights assigned to a role are only
> available to a user when that user is logged in with that role. Otherwise
> only the rights assigned to the user itself apply.
>
> Mark
>