Re: How can I see what permissions "VIEW SERVER STATE" has?

If that's the only way to determine the VIEW SERVER STATE permissions
then it's very kludgy but it wouldn't surprise me the Microsoft
doesn't have a way to figure this out. BOL is rife with omissions so
that's a highly suspect way of going about this.

So basically someone could grants VIEW SERVER STATE to a login so the
login can see one specific aspect of the the server they could be
allowing that user to see all sorts of other information but have no
way of knowing for sure what they are allowing that user to see.

.

Relevant Pages

  • Re: EXECUTE AS question
    ... However, it only returns one record, for the current session only ... (as it would for a user without the VIEW SERVER STATE permission). ... An alternative solution is to sign the procedure with a certificate, ... and then associate create a login for the certificate, ...
    (microsoft.public.sqlserver.security)
  • Re: EXECUTE AS question
    ... However, it only returns one record, for the current session only ... (as it would for a user without the VIEW SERVER STATE permission). ... and then associate create a login for the certificate, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.sqlserver.security)
  • Re: How can I see what permissions "VIEW SERVER STATE" has?
    ... But before I grant them VIEW SERVER STATE ... those permissions. ... and grant that login VIEW SERVER STATE. ...
    (microsoft.public.sqlserver.security)