Hi Thanks for the comments.
Yes, I am giving the role to the user, at the time of login. --- In [email protected], <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 >
