Database mail permission problem

• Sagar Sawant

  SSC Eights!

  Points: 853

  More actions

  November 8, 2011 at 1:23 am

  #250523

  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.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  November 8, 2011 at 3:18 am

  #1404344

  Duplicate post. No replies please.

  See here for replies: http://www.sqlservercentral.com/Forums/FindPost1201808.aspx

  -- Gianluca Sartori