Post reply

Access to System stored procedure

  • March 25, 2010 at 2:17 am

    #231126

    Hi Experts,

    One of our developer need access to system stored procedure sp_send_dbmail.

    How can i achive the same while giving only limited privileages ? Is is possible to give access only to that particular one?

  • March 25, 2010 at 3:22 am

    #1139468

    This is taken from BOL:

    “Execute permissions for sp_send_dbmail default to all members of the DatabaseMailUser database role in the msdb database. However, when the user sending the message does not have permission to use the profile for the request, sp_send_dbmail returns an error and does not send the message.”

    This means that you have to add the user’s login as a user to MSDB and add the user to DatabaseMailUser role.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • March 25, 2010 at 3:29 am

    #1139472

    Thanks Adi,

    I ran (grant exec on dbo.sp_send_dbmail to user_name) and now its accesible.

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

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