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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-11 : 06:16:33
|
| Carlos writes "I am using Windows Authentication and I am trying to automate detaching old DBs, but I always run into the same error message "User 'ACCNT\test1' does not have permission to run DBCC DETACHDB"Does the user have to belong to the sysadmin fixed server role only to be able to execute sp_detach_db? I have not been able to find that option in any other server role or database role.I just don't want to give sysadmin rigths to the people in charge of detaching old DBs.Any ideas?Carlos" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-07-11 : 06:19:19
|
| Yes, they have to belong to sysadmin to run it. Detaching a database should be left in the hands of an admin anyway. You might be able to work around it by creating a job that runs sp_detach_db and have the user run the job instead, but there's a certain risk associated with that approach. |
 |
|
|
|
|
|
sp_detach_db using Windows Authentication