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.
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?
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: 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: 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: Security Permission Issue with C# EXE on Intranet ... The default CAS permission grant for the intranet zone includes permission ... something in place for distributing CAS policy changes and, if not, your IT ... which is in the same directory as the C# .EXE on the server.... (microsoft.public.dotnet.languages.csharp)
Re: How to GRANT *all* permissions to *all* users? ...permission to do anything ... I'm asking because I recently converted from SQL Server 2000 to 2005 ...GRANT VIEW ANY DEFINITION TO public ... But I still can't ALTER tables. ... (microsoft.public.sqlserver.security)
