Re: GRANT VIEW SERVER STATE to Database Role

Frank,

Since it is a Server permission, it has to be a login.

If you have several domain logins to which you want to grant this permission, but you would like to limit how many times you grant this on the server, do the following.
1. Have all the logins that need this permission added to a Windows Group. (e.g. MyDomain\MyServerViewServerState)
2. Add the MyDomain\MyServerViewServerState as a login on your SQL Server.
3. GRANT VIEW SERVER STATE TO [MyDomain\MyServerViewServerState]

Now, all people in that group will have this permission. As you have users added or removed from the Windows group they will receive or lose these permissions as well.

Note that this is an extra permission for people who already have rights to the server through other logins, groups, and roles. It does not affect their other rights.

RLF

"Frank Uray" <FrankUray@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EB797207-6087-4ABE-A935-CF9B01238F4A@xxxxxxxxxxxxxxxx
Hi all

Is it possible to "GRANT VIEW SERVER STATE"
to a Database Role ?? Or does it has to be to a Login ??

Thanks and best regards
Frank Uray

.

Relevant Pages

  • Re: Allowing Anonymous write access only.
    ... need at least READ permission for login. ... > been set up so that anonymous FTP users have write access only, this> may seem insecure and we do get a certain ammount of hackers or> taggers testing the system by dropping test files and folders onto the> server, but because anonymous users do not have read access they soon> find that they cannot download anything they upload and go elsewhere. ... This is where my problems have started,> I initialy replicated all the IIS setting and NTFS permission from my> NT box on my 2003 box but so far have been unable to achive the same> result, it appaers that I can only grant anonymous write access if I ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: SQL Local Account Permission - Read Only on System Tables and
    ... Create a Windows group on the domain and have your developer logins added to ... VIEW SERVER STATE to that one login. ... can create your own server-level roles) and grant it VIEW SERVER STATE ...
    (microsoft.public.sqlserver.security)
  • RE: Login Error: 18456, Severity: 14, State:11
    ... The problem is the Login is denied. ... The SQL server error log shows the lines: ... The ONLY permission that permits login is the 'Control Server' permission. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.security)
  • Re: Complete Neophyte Question(s)
    ... You should not have to go Google to find out what WITH GRANT means. ... Server comes with online documentation on you hard disk. ... WITH GRANT is one of the more esotheric features in SQL Server in my ... Or does that depend on the permission? ...
    (microsoft.public.sqlserver.security)
  • Re: Shared Folders in WorkGroup Network
    ... login privileges, you are not going to get prompted. ... > permission and NTFS permission to everyone read in most cases. ... >>I have shared a folder on the server. ...
    (microsoft.public.win2000.networking)