Post reply

Set up a W2000 Group with read only Database Access

  • November 15, 2004 at 2:25 pm

    #102273

    I have a W2000 Group (SQLUsers) Set up with four users. I want to make it so the users of this group has read only access to all databases. Should I define the SQLUsers group as a member of the db_datareader Fixed Database Role? Or should I define it as a member of the db_denydatawriter Fixed Database Role? Am I  going about this the right way? I want to set up a group of users who only have read access to each user database?

    Thanks in advance, Kevin

  • November 15, 2004 at 3:06 pm

    #530190

    Adding the group to datareaders should be fine.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 16, 2004 at 10:20 am

    #530315

    Additionally, if you want the group to be in the db_datareader role for each new database, add the the group as a user and a member of the role in the Model database.  When a database is created, it takes it's settings from Model.

    Greg

    Greg

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

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