Shared SQL Server Hosting

• Chriss-232311

  SSC Enthusiast

  Points: 114

  More actions

  May 12, 2005 at 2:24 am

  #88400

  I need to setup access to SQL Server for multiple users, and would like to allow the users to do the following.

  Create/Drop/Edit Tables-SP's-Views-Indexes-Logins for there own database, but not be able to backup there databases etc.

  How is this done?

  Thanks in advance.

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  May 12, 2005 at 3:08 am

  #558298

  Add them to the db_accessadmin, db_securityadmin and db_ddladmin roles, and of course db_datareader and db_datawriter I suppose. Specifically do not add them to the db_owner or db_backupoperator roles.

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/