Re: Security DBCC

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/19/05 

Date: Mon, 19 Sep 2005 07:29:55 -0600

Hi,

SP_ATTCH_DB can be executed by the users who are in dbcreator sever fixed
role, but detach database can be
executed only by users in sysadmin role.

Thanks
Hari
SQL Server MVP

"klaus.bilger" <Klaus.Bilger@C-S-L.BIZ> wrote in message
news:e3L34zRvFHA.2948@TK2MSFTNGP15.phx.gbl...
> 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
>
>