Permissions for attach and detach

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  May 18, 2005 at 12:17 pm

  #93045

  SQL 2000

  I have some users that will need to attach and detach databases.  I do not want to give them sysadmin privileges. 

  Does anyone know of a way to give them the ability to attach and detach w/out granting sysadmin?

  Thanks,

  Jeff

   

   

  
  "Keep Your Stick On the Ice" ..Red Green

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  May 18, 2005 at 12:30 pm

  #559686

  Only members of the sysadmin and dbcreator fixed server roles can execute sp_attach_db and sysadmin to run sp_detach_db.

  db_backupoperator  can run backup and dbcreator is able to execute restore.

  I suggest you to control how and where the databases are created and database files be located, no users.

• Michael David

  Right there with Babe

  Points: 788

  More actions

  May 19, 2005 at 11:14 am

  #559937

  You may create a SP to perform this. Then grant execute access to the specific users.

  Michael.