Scenario:
We have created a new Login (ie: Test) and Login into this account and able to access the Databases.
When I try to execute DMVs like SYS.dm_exec_connections, The following Err occurred.
Msg 297, Level 16, State 1, Line 1
The user does not have permission to perform this action.
So, The login required some Server permission to access the DMVs. correct ?
Login into sa account and grant the following permission to login: test
USE master
GO
GRANT VIEW SERVER STATE TO [test]
The View Server State permission granted to the Test Login.
Now we can access the DMVs.
No comments:
Post a Comment