Discussion in 'SQL Server 2005 General DBA Questions' started by satya.sqldba, Jan 30, 2007.
What does "grant view server state to 'login'" do? What is the use of that?
If an administrator on SQL Server 2005 wants full backward compatibility, and does not want to restrict metadata visibility, a new SQL Server 2005 permission can be used. The permission, VIEW DEFINITION, allows a user or role to see the definition of an object or all objects within a particular scope. So if an administrator ran the following two statements, all users would be able to view all the metadata on a SQL Server instance:
GRANT VIEW ANY DEFINITION TO public
GRANT VIEW SERVER STATE TO public
Got it. I think it is mainly used to give the user permission to view the locks in a server.
Separate names with a comma.