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 |
|
MirandaJ
Starting Member
35 Posts |
 Posted - 2005-12-27 : 16:01:43
|
| we are using windows authentication. Is there a faster way to set permissions for each database than to go through each table and set them? Currently, to set the permissions from SQL Server Enterprise Manager, I click on Security > logins > select the properties for the IUSR account > Database Access > then check off each database that we allow access to. Next I go through each tables properties and set the permissions. Is there an easier, faster way to do this?Miranda |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-28 : 06:06:14
|
| How about creating a ROLE that has all the appropriate permissions on the tables, and then assigning that ROLE to each new Login / User?If you want users to have SELECT ( or SELECT + UPDATE / DELETE / INSERT) on EVERY table in the DB then you can assign them the "pre-defined" roles db_datareader / db_datawriter - they will also cover any tales that you may add in the future.My suggestion would be that you make a role of your own, and that way you can have multiple roles in the future if you find you need to have different permissions for different "groups" of users.Kristen |
 |
|
|
MirandaJ
Starting Member
35 Posts |
Posted - 2005-12-28 : 09:23:23
|
| Thank you Kristen. I did a search on SQL Server Roles and found an excellent article which helped me create a new database role and set it up. (I needed to allow insert, update on some tables but not on others, and only one table has delete allowed so I didn't dare use the predefined db_datawriter role) This is indeed much faster. Thank you for your help.Miranda |
|
|
|
|
|
|
setting permissions