question

siera_gld avatar image
siera_gld asked

report against system views

I am trying to write a report against the failed mail system views. My UserID on the report server is on the msdb db, and i have added that user to the db_data_reader role in the db. Granted select and view definition to the UserID appropriately in the msdb db. The Report Rendering is not failing but the result set does not return. In the management studio, I am logged in as a different user and get results without any problems. I have also greanted select permissions to the UserID on all of the underlying sysmail....tables that could be utilized by the sysviews.. SYSMAIL_FAILEDITEMS, SYSMAIL_EVENT_LOG
permissionssystem-views
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Fatherjack avatar image
Fatherjack answered
As per Books Online http://msdn.microsoft.com/en-us/library/ms187747(SQL.105).aspx: > Permissions > Granted to sysadmin fixed server role and databasemailuserrole database role. When executed by a member of the sysadmin fixed server role, this view shows all failed messages. All other users only see the failed messages that they submitted.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.