Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
whizsql
Starting Member
17 Posts |
 Posted - 2008-12-09 : 16:57:21
|
| I am wondering how can I grant select access to all tables under a database in SQL Server 2005 at once?I have a role called "privacy Users" created, and a AD group which is a member of this role.Our aim is to provide AD group members with 'select' access to all the tables and views under a database.That database has 1000s of tables and granting access to all those one by one, through database role properties->Securables wizard is nearly impossible.Is there any way I can grant access to selected database objects at once? At a later point of time, we may limit the access to the tables as well.Please help..Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
whizsql
Starting Member
17 Posts |
Posted - 2008-12-09 : 20:38:07
|
| But, if I want to revoke a few permissions in the future, how would I handle with db_datareader role?Can I edit them? This is one of the reason to create a new role. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Role Permissions to database objects