Post reply

Execute permissions on extended stored procedures

  • November 8, 2011 at 9:10 am

    #390797

    Trying to execute an extended store procedure from an application (access)

    I get the following message:

    [Microsoft][ODBC SQL Sever Driver][SQL Server]EXECUTE permission denied on object 'xp_sqlagent_enum_jobs', database 'master', owner 'dbo'. (#229)

    Is there any special issue about permissions on extended store procedures of master database?

    Thanks

  • November 14, 2011 at 1:55 pm

    #1407516

    I would recommend you create a stored procedure that returns the data you want, sign it with a certificate so it can operate with elevated permissions and then grant your app execute permissions to the new stored procedure.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply