Post reply

Database mail permission problem

  • November 7, 2011 at 11:17 pm

    #245698

    Hi guys,

    I am getting error when trying to execute database profile and database account through stored procedure.

    I already executed,

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Database Mail XPs', 1;

    GO

    RECONFIGURE

    GO

    But getting below errors when executing stored procedure,

    The SELECT permission was denied on the object 'sysmail_profile', database 'msdb', schema 'dbo'. The SELECT permission was denied on the object 'sysmail_account', database 'msdb', schema 'dbo'. The EXECUTE permission was denied on the object 'sysmail_add_profile_sp', database 'msdb', schema 'dbo'. The EXECUTE permission was denied on the object 'sysmail_add_account_sp', database 'msdb', schema 'dbo'. The EXECUTE permission was denied on the object 'sysmail_add_profileaccount_sp', database 'msdb', schema 'dbo'. The EXECUTE permission was denied on the object 'sysmail_add_principalprofile_sp', database 'msdb', schema 'dbo'.

    Any help would be greatly appreciated.

  • November 8, 2011 at 2:19 am

    #1404316

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1201808-359-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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