Security DBCC

From: klaus.bilger (Klaus.Bilger_at_C-S-L.BIZ)
Date: 09/19/05


Date: Mon, 19 Sep 2005 15:18:50 +0200

hi @ll
I have a problem with the rights on DBCC
I know that only SysDB can run DBCC commands but I need
to run sp_detachDB and sp_attach_DB without a sysadmin account
both SP has excecute right for the user but I get still an error back
"user XXX does not have permission to run dbb detachdb"

is there any way to run the command without SysAdmin Rights?

thanks

klaus