Re: Setting permissions for multiple tables in a database
From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 09/06/02
- Next message: Dan Guisinger: "?? unable to access SQL Server w/ sa account unless user is Administrator on local machine"
- Previous message: Ed Noepel: "Setting permissions for multiple tables in a database"
- In reply to: Ed Noepel: "Setting permissions for multiple tables in a database"
- Next in thread: Dan Guzman: "Re: Setting permissions for multiple tables in a database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Andrew J. Kelly" <akelly@targitinteractive.com> Date: Fri, 6 Sep 2002 11:53:10 -0400
Just assign them to the db_datareader role for that DB.
-- Andrew J. Kelly SQL MVP Targitinteractive, Inc. "Ed Noepel" <noepel@yahoo.com> wrote in message news:ba8a01c255b9$c818bb90$2ae2c90a@phx.gbl... I would like to give a user SELECT permission on all tables in a database (which contains thousands of tables). I'm not going to hit the checkbox next to each table. Is there a more constructive way of changing permissions for a large number of tables? Maybe using a system table somehow?
- Next message: Dan Guisinger: "?? unable to access SQL Server w/ sa account unless user is Administrator on local machine"
- Previous message: Ed Noepel: "Setting permissions for multiple tables in a database"
- In reply to: Ed Noepel: "Setting permissions for multiple tables in a database"
- Next in thread: Dan Guzman: "Re: Setting permissions for multiple tables in a database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
