How to grant sendmail permission to sql server user?

Create a mail profile first using

1. Management - > Database Mail object

2. Create the desired user under Security -> Logins object




Run the following permission script

use msdb
exec sp_addrolemember 'DatabaseMailUserRole', 'sqlUser'

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp  
@principal_name = 'sqlUser',  
@profile_name = 'sqlMailProfileName',
@is_default = 0