Home Forums SQL Server 2005 SQL Server 2005 Security How do i grant permission to msdb.dbo.sp_send_dbmail ? RE: How do i grant permission to msdb.dbo.sp_send_dbmail ?

  • December 27, 2011 at 6:24 pm

    #1425907

    Lowell:

    Thank you for the detailed instructions. I have three questions if you have the time to answer them but if your time is limited an answer to question #1 would be greatly appreciated.

    Question #1:

    I am using SQL authentication and not Windows authentication. How would this change your instructions?

    Question #2:

    I have dbmail working but I noticed that the profile that I am using in the procedure is not public and not the default profile. Could the solution be as simple as changing this profile to Public and Default profile?

    Question #3:

    In attempting to resolve the issue I used SSMS and in Database > msdb > Security > Roles > Database Roles > DatabaseMailUserRole > Properties > General > Schemas owned by this role > I checked db_owner. Obviously this did not solve my problem. However, now I cannot uncheck db_owner. It is grayed out. Do you know how I can uncheck db_owner?

    Thanks

    Howard