Security DBCC
From: klaus.bilger (Klaus.Bilger_at_C-S-L.BIZ)
Date: 09/19/05
- Next message: Hari Prasad: "Re: Security DBCC"
- Previous message: mwastesson_at_gmail.com: "Is there a way to find out which login who created a login?"
- Next in thread: Hari Prasad: "Re: Security DBCC"
- Reply: Hari Prasad: "Re: Security DBCC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Hari Prasad: "Re: Security DBCC"
- Previous message: mwastesson_at_gmail.com: "Is there a way to find out which login who created a login?"
- Next in thread: Hari Prasad: "Re: Security DBCC"
- Reply: Hari Prasad: "Re: Security DBCC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]