Friday, March 15, 2013

more on sending mail via SQL

Something missing from this is permissions. Grant EXECUTE and also double-click on the user in SSMS to add database role memberships. Good memberships to hold are:

  1. db_accessadmin
  2. db_backupoperator
  3. db_datareader
  4. db_datawriter
  5. db_ddladmin
  6. db_owner
  7. db_securityadmin

No comments:

Post a Comment