Possibility to grant permission for DBCC commands for normal users

• srisagar_p

  SSChasing Mays

  Points: 623

  More actions

  January 13, 2009 at 8:35 am

  #217428

  Dear members,

  Please help me regarding this query.

  As of my knowledge i know that DBCC commands are worked under sysuser or Admin users only.

  My question: Is any other way to give grant permissions to execute DBCC commands for the normal sql authenticated users.

  Please help me...... Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 13, 2009 at 10:29 am

  #926068

  What version of SQL Server are you using? You really need to post in an appropriate forum.

  For SQL Server 2008 permissions vary by DBCC command, some require sysadmin, some can be executed by anyone in the public role.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736162

  More actions

  January 13, 2009 at 12:51 pm

  #926187

  Moving to 2005 security forum for now.