Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Security DBCC
0 views
Skip to first unread message
klaus.bilger
Sep 19, 2005, 9:18:50 AM9/19/05
to
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"
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
Hari Prasad
Sep 19, 2005, 9:29:55 AM9/19/05
to
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....@C-S-L.BIZ> wrote in message
news:e3L34zRv...@TK2MSFTNGP15.phx.gbl...
0 new messages