SSMS Standard Reports Permissions

[djj55]

Hello, SQL 2008 R2
I have a user that would like to check "Transaction Log Shipping Status" but he does not have admin privileges. Is there a way to give him permission to view the information?

I have tried

grant view server state to [user]
grant view database state to [user]

Thank you,


djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[mkal]

You could try granting execute permissions to the login for the stored procedure: sp_help_log_shipping_monitor