What rights do I need to run DBCC commands?

Question

Do I need to be sysadmin to run DBCC commands on SQL Server? Or is db_owner rights enough?

score 3 · Accepted Answer · answered Sep 24 '10 at 12:52

3

Not all of them are the same, but at least one explicitly requires sysadmin.

See the Permissions section of DBCC INPUTBUFFER on msdn- this requires sysadmin. DBCC CHECKDB only requires db_owner.

Are there any in particular that you're looking to use?

answered Sep 24 '10 at 12:52

Will

1

You can see all of the DBCC Commands for SQL 2008 here: http://msdn.microsoft.com/en-us/library/ms188796.aspx Each has a section on permissions. – Will Sep 24 '10 at 12:54
1

I tried to run: DBCC SQLPERF(LOGSPACE). From your link I can find that I need "view server state" permissions. – atricapilla Sep 24 '10 at 13:15
`MEMORYSTATUS` is not documented :-/ – Daniel Fisher lennybacon Dec 09 '20 at 14:29

1 Answers1