Grant view server state to

Discussion in 'Databases' started by cotega, May 1, 2012.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. cotega

    cotega

    I need to execute "GRANT VIEW SERVER STATE TO user1" in my SQL Server database so that my user can execute some system tame queries. To do this I need to execute this in both the master and user database. Unfortunately, I do not have the permissions to do this in the master database.

    Is there an alternate way to accomplish this?
     
    cotega, May 1, 2012
    #1
  2. dmitri

    dmitri DiscountASP.NET Staff

    It is not possible to execute this statement as it requires administrative permissions at instance level. Those permissions cannot be granted on our shared servers for the security and performance reason.
     
    dmitri, May 1, 2012
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page