Post reply

Create Sql Login

  • January 10, 2011 at 12:51 pm

    #148190

    I created a user login and gave only datareader and datawriter roles to the specific database. however, datawriter can insert,update and delete. I dont want the login to have delete access.

    What is the correct role to choose for the login?

  • January 10, 2011 at 1:21 pm

    #1271595

    If you do not want the user to DELETE, then you have to remove it from the db_datawriter role and create your own role, then grant the appropriate permissions to that *custom* role.

  • January 10, 2011 at 2:01 pm

    #1271621

    Thank you. I got it now.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply