Re: Permissions to run DBCC SHOWFILESTATS

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 11/20/03 

Date: Wed, 19 Nov 2003 22:08:12 -0800

Hi Sasquatch

There are many commands for which permission cannot be granted; many DBCC
commands, including this one, are in that category. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Sasquatch" <me@nowhereinparticular.com> wrote in message
news:vroctgnrlcqt5b@corp.supernews.com...
> All,
>
> We have a custom app (that unfortunately can't be modified any time soon)
> that uses the undocumented command "DBCC SHOWFILESTATS" to get data file
> information. However, we need to allow non-admins/dbowners to use this
> function. As I am not an SQL Server Admin, I haven't the faintest idea
> how to allow this. I've tried GRANTing the right with no luck. Can anyone
> help this poor schmoe out and tell me exactly how to grant execute rights
> for DBCC SHOWFILESTATS on a given database (let's say Northwind for
> example)?
>
> Many thanks in advance.
>
> --
> --Sasquatch
>
> "And I thought 'Reverend Billy ...', you know, which is good 'cause when I
>  think 'Reverend Debra ...', that's another set of problems altogether."
>                                 -- Rev. Billy C. Wirtz

Relevant Pages

  • Re: Curious performance experiment
    ... >following commands ... >DBCC FREEPROCCACHE clears the procedure cache and causes ad hoc queries to ... >if you want to clear the data cache you will need to use DBCC ... >specific database on a SQL Server, ...
    (microsoft.public.sqlserver.server)
  • Re: Receiving SQL Server Error messages in SQL Server Log
    ... I haven't use the dbcc freeze_io and thaw_io. ... >The commands are depreciated in SQL Server 2000 and are ... >recommended to be used due to the depreciation as well as ... >the potential for these commands to hang the server. ...
    (microsoft.public.sqlserver.server)
  • Re: Receiving SQL Server Error messages in SQL Server Log
    ... Most likely due to using dbcc freeze_io and thaw_io. ... The commands are depreciated in SQL Server 2000 and are not ... recommended to be used due to the depreciation as well as ...
    (microsoft.public.sqlserver.server)
  • Re: 3 Simple Security SQL Statements
    ... If you run the SELECT in a query window, it generates the list of commands ... There is procedure called sp_executesql that will take a string and execute ... Kalen Delaney, SQL Server MVP ... Builds a list of text commands. ...
    (microsoft.public.sqlserver.security)
  • Re: newbie problem: updating an access db
    ... modifying the code to use SQL Server it still exhibited the same ... changed the path to the supplied access .mdb file in the web.config ... the delete and update commands, so now they just test whether Adnum= ?. ... get this code to work, I don't want to start modifying it to use MSSQL, ...
    (microsoft.public.dotnet.framework.aspnet)