Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davy_boy2000
Starting Member
28 Posts |
 Posted - 2002-09-24 : 09:25:59
|
| I want to execute DBCC ShowFileStats but don't want the user to be a system administrator or db_owner.Does anyone know of a way to allow the sql user to be able to execute a DBCC command?I tried adding the user as part of the fixed db role db_backupoperator, but that doesn't allow execution of DBCC ShowfileStats. |
|
|
|
|
|
DBCC ShowFileStats