Permission on sp_detach_db

• derek_chen

  Valued Member

  Points: 65

  More actions

  April 20, 2004 at 8:40 pm

  #82670

  I create a login with role database creater but it can not detach a database. Why? While executing sp_detach_db I got the error "User 'xxx' does not have permission to run DBCC DETACHDB.". So what kind of permission should I grant to this login? Actualy what I want to do is let it can just attach and detach a specific database, no other operations allowed. Is it possible to do that? Thanks.

• Kenneth Wilhelmsson

  SSC-Dedicated

  Points: 30043

  More actions

  April 21, 2004 at 3:17 am

  #503607

  -- BOL --

  Permissions

  Only members of the sysadmin fixed server role can execute sp_detach_db.

  -- End BOL --

  BOL is your friend, many words of wisdom can be found there.

  =;o)

  /Kenneth