Re: who can execute DBCC commands ?

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 11/19/04 

Date: Thu, 18 Nov 2004 21:37:15 -0800

Hi Hassan

Have you tried Books Online? This command is fully documented and says:

DBCC INPUTBUFFER permissions default to members of the sysadmin fixed server
role only, who can see any SPID. Other users can see any SPID they own.
Permissions are not transferable. 

-- 
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@hotmail.com> wrote in message 
news:Ozv%23abfzEHA.2040@tk2msftngp13.phx.gbl...
> Its dbcc inputbuffer..
>
> "Adi" <adico@clalit.org.il> wrote in message
> news:1100840640.763054.210050@c13g2000cwb.googlegroups.com...
>> It depends on which DBCC command you are talking about.  There are
>> commands that you need to sysadmin in order to run them (for example
>> DBCC traceon) and other commands that you can be dbo (for example DBCC
>> opentran).  Sometimes you can find DBCC statements that you also don't
>> need to be the dbo.  For example DBCC Checkident can be used by
>> ddladmin and DBCC sqlperf can be used by anyone that can logon to the
>> server.
>>
>> Adi
>>
>
>

Relevant Pages

  • Re: SQL 2005 --> Replicate Production DB to Development DB
    ... The DBCC CHECKIDENT command now ... SQL2005 SP2 fixes a DBCC CHECKIDENT bug with the exact symtoms that you ... We are using push replication so it looks like I will have to execute the ...
    (microsoft.public.sqlserver.replication)
  • FWD: RE: [dbi] RE: succint view of problem - getting results from DBCC INDEXDEFRAG - DBD::ODBC
    ... Subject: [dbi] RE: succint view of problem - getting results from DBCC ... ** command: ... If DBCC printed error messages, ...
    (perl.dbi.users)
  • Re: How to deny DBCC SQLPERF(logspace)
    ... DBCC statements that act as Database Console Commands for Microsoft? ... I know that if we can find the place where the permissions of each DBCC ... command stored, we can update the table directly to change the permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 --> Replicate Production DB to Development DB
    ... We are using push replication so it looks like I will have to execute the ... But I am having problems with the 'DBCC CHECIDENT' command. ... Consider the following .pre file generated from the snapshot agent ...
    (microsoft.public.sqlserver.replication)
  • Re: DBCC error 913
    ... Then I run the command sp_dboption dbname,'Single user',true also. ... this command runs inside a cursor and DBCC checkdb commands starts after that. ... >> This is simple DBCC script I am running on the server every sunday. ... >> database is online and in live. ...
    (microsoft.public.sqlserver.server)