Question

You have to configure a SQL Server instance to ensure that a user named U1 can send mail by using Database Mail. Solution: You add the DatabaseMailUserRole to U1 in the master database. Does this solution meet the goal?

A. True
B. False

Answer 1

The solution mentioned in the question is false. To configure SQL Server to allow a user to send mail using Database Mail, the DatabaseMailUserRole should be assigned to the user in the msdb database.

Step-by-step explanation:

The solution mentioned in the question is false.

To configure SQL Server to allow a user to send mail using Database Mail, the DatabaseMailUserRole should be assigned to the user in the msdb database, not the master database. The DatabaseMailUserRole is a built-in database role in SQL Server that grants the necessary permissions to use Database Mail. By assigning this role to the user in the msdb database, the user will have the required permissions to send mail using Database Mail.