Re: who can execute DBCC commands ?

From: Mike Hodgson (mwh_junk_at_hotmail.com)
Date: 11/19/04 

Date: Fri, 19 Nov 2004 17:10:14 +1100

An alternative is to use the new UDF Microsoft introduced in SP3 (I think)
::fn_get_sql() as per Kalen's article in SQL Mag a year ago:
http://www.winnetmag.com/Windows/Articles/ArticleID/39664/pg/2/2.html

But I don't know what default permissions are necessary to run it (info is a
little hard to come by) but, being a UDF in the master DB, you might be able
to GRANT different permissions to SELECT from it (or perhaps not <shrug>). 

-- 
Cheers,
Mike
"Kalen Delaney" <replies@public_newsgroups.com> wrote in message 
news:OfXiinfzEHA.3116@TK2MSFTNGP10.phx.gbl...
> 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: who can execute DBCC commands ?
    ... ::fn_get_sqlas per Kalen's article in SQL Mag a year ago: ... to GRANT different permissions to SELECT from it. ... >> Its dbcc inputbuffer.. ... >>> It depends on which DBCC command you are talking about. ...
    (microsoft.public.sqlserver.server)
  • 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)
Quantcast