profile name is not valid，The EXECUTE permission was denied on the object 'sp_send

profile name is not valid，The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.

使用不是sysadmin权限的账号执行存储发邮件，报异常profile name is not valid，

        EXEC msdb.dbo.sp_send_dbmail
            @profile_name = 'mail',
            @recipients = 'xx',
            @attach_query_result_as_file = 0,
            @body = 'tttt',
            --@file_attachments='',
            @subject='xx',
            @body_format = 'xx'

解决

1.给开sysadmin权限

2.如果不能给开sysadmin权限，则要将该配置文件改为公用。

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
    @principal_name = 'public',
    @profile_name = 'Mail',
    @is_default = 1 ;

并给该账号开启msdb的DatabaseMailUserRole权限，

否则报错

The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.