Post reply

creating new user - what permisssions allow read/write

  • December 2, 2008 at 8:52 pm

    #202460

    Hi,

    I have created a user, but I don't know what "owned schemas", or "role members" to put the user into. I want this person to be able to read and write to the database but not much else - can someone guide me in creating the basic user using sql server authorization?

    Thank You

  • December 3, 2008 at 2:40 am

    #906695

    If you want to give read\write permissions on all tables add the user to the roles db_datareader and db_datawriter. But remember that this will not give them permission to execute stored procedures.

    [font="Verdana"]Markus Bohse[/font]

  • December 3, 2008 at 8:48 pm

    #907325

    Thank You

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

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