October 10, 2014 at 5:40 pm
Hi,
To Grant select permission on views
just running the first script works or do we need to give view server state also. What is the additional permissions we are giving by running the second statement
USE Testdb;
GRANT SELECT ON Test_View TO Ramana1;
(or)
USE Testdb;
GRANT SELECT ON Test_View TO Ramana1;
GRANT VIEW SERVER STATE to Ramana1;
October 10, 2014 at 6:05 pm
The second one gives permissions on certain system views and functions. Especifically, Server-scoped dynamic management views and functions.
It isn't a big security risk, but you definitely don't need that grant.
http://serverfault.com/questions/191661/what-can-user-do-with-view-server-state-permissions
October 10, 2014 at 6:51 pm
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply