Database Mail definition - confusing

Hello,

>From BOL:
For improved security, Database Mail manages access to mail profiles. A
profile may be public or private. Public profiles are available for all
members of the DatabaseMailUserRole database role in the msdb database.
They allow all members of the DatabaseMailUserRole role to send e-mail
using the profile.
To use a private profile, sysadmin must grant users permission to use
the profile. In addition, execute permission on the sp_send_dbmail
stored procedure is only granted to members of the
DatabaseMailUserRole. A system administrator must add the user to the
DatabaseMailUserRole database role in order for the user to send
e-mails.
What's confusing that that DatabaseMailUserRole is a PUBLIC role.
However, if you create a private profile, it says you must add the user
to the DatabaseMailUserRole in order for the user to send emails. That
would make the any member of this role a public profile?
I guess I am confused about the language here, so in effect I have no
clue what the end result of adding a user from a PRIVATE profile into a
role that is available for PUBLIC profiles.Hi
If I have interpreted your interpretation right, I think there is some
confusion between a role which is not a fixed database role, and the public
database role.
John
"tootsuite@.gmail.com" wrote:

> Hello,
>
> For improved security, Database Mail manages access to mail profiles. A
> profile may be public or private. Public profiles are available for all
> members of the DatabaseMailUserRole database role in the msdb database.
> They allow all members of the DatabaseMailUserRole role to send e-mail
> using the profile.
> To use a private profile, sysadmin must grant users permission to use
> the profile. In addition, execute permission on the sp_send_dbmail
> stored procedure is only granted to members of the
> DatabaseMailUserRole. A system administrator must add the user to the
> DatabaseMailUserRole database role in order for the user to send
> e-mails.
> What's confusing that that DatabaseMailUserRole is a PUBLIC role.
> However, if you create a private profile, it says you must add the user
> to the DatabaseMailUserRole in order for the user to send emails. That
> would make the any member of this role a public profile?
> I guess I am confused about the language here, so in effect I have no
> clue what the end result of adding a user from a PRIVATE profile into a
> role that is available for PUBLIC profiles.
>