app role has exec permission but still can't execute sp

From: Diederik (diederikvanpeer@hotmail.com)
Date: 11/07/02 

From: "Diederik" <diederikvanpeer@hotmail.com>
Date: Thu, 7 Nov 2002 02:18:43 -0800

Hi all,
I've set up an application role in my SQL2K database as
well as some users with no permissions. All permissions
(including execute permissions) are granted to the
application role.
The users log on to the database through my Visual Basic
application. After succesful logon, the security context
is switched to the application role's via 'sp_setapprole'
(called from within the VB application). So far so good.
However, when I try to execute a stored procedure through
the ADO command object, I get the 'EXECUTE permission
denied on object...' message. I don't understand this, I'm
positive that the application role has the execute
permission for the stored procedure, and I'm also sure
that the call to sp_setapprole went ok. Am I missing
something here?

Any help is appreciated.

Diederik

Relevant Pages

  • Multiple Database Security - How to handle
    ... The problems are security maintenance. ... to the store procedure and permissions to the DM for the ... a stored procedure that accesses DM to get employee info. ... has execute permissions then the procedure is executed as ...
    (microsoft.public.sqlserver.security)
  • Re: Table Type Permissions
    ... Users need EXECUTE permissions in the table type in order to use the type to pass table-valued parameters to a stored procedure. ... REFERENCES permission on the type is needed for a user to create a stored procedure that uses the type as a parameter. ... The SQL 2008 BOL topic on GRANTing permissions to TYPEs is not explicit on what the results of granting specific permisisons are. ...
    (microsoft.public.sqlserver.server)
  • Re: sa privileges and roles
    ... permissions of that account. ... Another option is to create a dbo-owned user proc in an sa-owned user ... in your user database and grant execute permissions only on your user proc. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: wshShell.Run - permission denied
    ... cmd.exe to ensure that the IUSR_CPUNAME and IWAM_CPUNAME accounts have ... dim WshShell, retCode ... should have at least read and execute permissions to the CSCRIPT.exe ...
    (microsoft.public.scripting.wsh)
  • Re: Problem with Performance Monitor Alerts and "Run As" command
    ... If it runs as an admin then there must be a permissions problem. ... First check that the account has read and execute permissions to the ... script that you are running, and also that BATCH has permissions to ... When creating the Performance Alert and this user is put into Administrators ...
    (microsoft.public.windows.server.general)