creating separate user for each database

• sedj

  SSC Veteran

  Points: 216

  More actions

  October 4, 2010 at 7:35 am

  #228942

  Anyone have any tips on how i would create a separate user for each database im running? I have around 15 databases in my SQL Server 2005. I want each user to have access to it's specific database, not one of the others. I also want the user to only be able to run:

  SELECT

  INSERT

  UPDATE

  ALTER

  and also sp_server_info.

  Anyone have any recommendations or script to perform this?

• Chris Howarth-536003

  SSCommitted

  Points: 1775

  More actions

  October 5, 2010 at 2:23 pm

  #1232068

  The following links will point you in the right direction:

  CREATE LOGIN (Transact-SQL)

  CREATE USER (Transact-SQL)

  GRANT (Transact-SQL)

  The links point to documentation for SQL Server 2008 R2, but the syntax for the tasks you need to perform is the same for SQL Server 2005.

  Chris