I'm having trouble adding a user to the DatabaseMailUserRole so that he can send notifications for one database. I have created a Login for this user and mapped him to the database. He is assigned to the public role. Next, I tried assigning him to the DatabaseMailUserRole with the following statement:
"EXEC AdventureWorks.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole', @membername = 'TestAccount'; GO
, but got the error: "The role 'DatabaseMailUserRole' does not exist in the current db"".
What can I do to enable this user of this database to configure and send DBMail?
Thanks.