Subject Re: [firebird-support] Firbird + 1.5 Issue with User and Role
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
> 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.