Initially I was getting a "no SELECT privilege" error when attempting to query contents for a report I need to create. So we granted DatabaseMailUserRole
in MSDB to my account - I see columns, but none of the data we know to exist.
What am I missing that needs to be done for my account to see the data?
Shows
sysmail_faileditems
definition isLooking at
sysmail_allitems
. The definition of that isSo it looks like you need to be in the sysadmin role to see all results or the sending user to see filtered results.