permissions to run @@version

• trans54

  Ten Centuries

  Points: 1357

  More actions

  March 17, 2009 at 4:48 pm

  #129104

  What a minimum permissions can i add to non sysadmin in order to run @@version?

  Thanks

• SQL_DBA_3

  SSCarpal Tunnel

  Points: 4772

  More actions

  March 17, 2009 at 11:04 pm

  #961578

  I think even "public" role can run this...not sure

  Otherwise look for "View server state" permission

• Mohit K. Gupta

  SSChampion

  Points: 12130

  More actions

  March 17, 2009 at 11:34 pm

  #961593

  SQL Reddy is correct; I created a new user with only connect rights to SQL Server it was able to run @@Version successfully.

  Thanks.

  [font="Arial"]---

  Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
  Microsoft FTE - SQL Server PFE

  * Some time its the search that counts, not the finding...
  * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

  How to ask for help .. Read Best Practices here[/url].

• trans54

  Ten Centuries

  Points: 1357

  More actions

  March 18, 2009 at 10:27 am

  #962075

  Thanks a lot for reply's.