Permissions

Grant View Server State

Grant View Server State

There are lots of Dynamic Management Objects (DMO’s, more commonly referred to generically as DMV’s) that require extra permissions. Without having these permissions there are a number of diagnostic queries that you cannot perform. Whilst one way to deal with this is to make users a member of the sysadmin group, it really doesn’t adhere […]

GRANT VIEW DEFINITION

Earlier today I was asked to elevate the permissions of a user who already had read only access to a database so they would be able to see stored procedures and other programmable objects it’s something that comes up every so often so worth while writing a few lines as it will undoubtedly help somebody out.