how to create appropriate user for a specific database?

• Khanh Nguyen

  SSC Enthusiast

  Points: 141

  More actions

  April 9, 2004 at 12:55 am

  #161358

  hi all,

     I want to create a user that only can select, insert, update, delete on a specific database, can anyone tell me how to do?

    Currently I have to assign that user into group System Administrator. It seems if I want to restrict a user to 1 database, I must also point out every tables and columns in that database !!! that's really a very arduous work.

  Thanks in advance,

  Khanh

• wz700

  SSCertifiable

  Points: 7133

  More actions

  April 9, 2004 at 8:34 am

  #502301

  Add the user as member to the specific database roles.

  Particular db_datawriter and db_datareader.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  April 9, 2004 at 10:13 am

  #502319

  You want to use roles, as mentioned above. Either those mentioned above or make your own.