Re: How to add VIEW SERVER STATE permissions

Very good. I guess you can tell that I never use that dialog. :) - RLF
"spinkid" <spinkid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EFB01F47-BF58-410B-990F-C0F91F46BCFE@xxxxxxxxxxxxxxxx
Found out how to do it.

1. Right mouse click the SQL Server and go to Properties
2. Go to Permissions in select a page
3. Find the login you want to assign the permission to in the top box
4. In the bottom box go all the way to the bottom you will find "View
Server State" and put a check mark in the Grant box and click OK.

"Russell Fields" wrote:

spinkid,

I don't think there is a SSMS interface for this permission. You can run
the following command:

GRANT VIEW SERVER STATE TO YourLogin

If you have several domain logins (the people who are the DBOs in
question)
you could have their logins added to a Windows Group, make that group a
login on SQL Server, and grant the rights to the group. All the logins
in
the group will inherit the permission.


RLF

"spinkid" <spinkid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:47857D98-A1D6-4557-B61F-263268F3444C@xxxxxxxxxxxxxxxx
I need to have one of the DBO's run some code on a SQL2005 server
database
that will recommend indexes on a particular database that they have DBO
rights to. However I found out that I need to give them "View Server
State"
permission to run this code. I don't see how to give them this
permission
using the console. Can some help me?





.

Relevant Pages

  • Re: Long delay before Drives & Files appear in My Computer & Address Bar
    ... > SERVICE JEFF-DZP8HX39G2 The machine-default permission settings do not ... > grant Local Activation permission for the COM Server application with ... > Ratcliff JEFF-DZP8HX39G2 The Adobe LM Service service was successfully ... > within the required timeout. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... 2- Mixed Authentication (through SQL Server logins and Windows accounts) ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL Server execute permission denied on object
    ... This is a permission problem: the Login account or the required permissions ... have not been set up properly on the remote database. ... Recently the SQL part was moved to a new server. ... SQL Server execute permission denied on object ...
    (microsoft.public.access.adp.sqlserver)
  • Re: db_owners unable to see login list
    ... Server 2003 R2 X64 Enterprise Edition. ... We have hundreds of logins on the ... is no permission VIEW ANY LOGIN, but there is a server-level VIEW ANY ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Network shares cannot connect
    ... After a reboot, domain users cannot access any shares on the SBS server, ... Microsoft Online Newsgroup Support ... let's focus on the Users Shared Folder first. ... To check this permission, please click the Advanced button, ...
    (microsoft.public.windows.server.sbs)