question

vijay 2 avatar image
vijay 2 asked

Permission denied issue in SQL Server 2008?

Hello everyone, I have created one user with read and write permissions. While he executing queries on sys databases and DMV’s facing the permission denied issue. Msg 297, Level 16, State 1, Line 1 The user does not have permission to perform this action. Now he is asking full access for all databases in all server instances so which is the best way to give him full access on all databases in server.We are planing to give him db owner access but i need to know the best way to give the access. Please suggest. Thanks in advance.. Veejay.
security
1 comment
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.

Blackhawk-17 avatar image Blackhawk-17 commented ·
Not asking for too much are they :)
0 Likes 0 ·

1 Answer

·
sp_lock avatar image
sp_lock answered
DMV's require the user to have "VIEW DATABASE STATE" or "VIEW SERVER STATE " See [link][1] for further details [1]: http://technet.microsoft.com/en-us/library/ms188754.aspx
1 comment
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.

Håkan Winther avatar image Håkan Winther commented ·
+1 For your answer.
0 Likes 0 ·

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.