question

ruancra avatar image
ruancra asked

User with limited access to see all spid's when running sp_who2

Hi all Is there a way to give a user with limited access permission to view all spid's when executing sp_who2. Currently the user can only view it's own spid when running sp_who2. Thanks
stored-proceduresaccess
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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

1 Answer

·
eghetto avatar image
eghetto answered
Write a wrapper stored procedure 'with execute as' a priviliged account. See here: [ http://www.sqlservercentral.com/Forums/Topic598645-359-1.aspx#bm773666][1] [1]: http://www.sqlservercentral.com/Forums/Topic598645-359-1.aspx#bm773666
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

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.