June 11, 2013 at 1:55 pm
I am working on a sql database which has multiple schemas. Lets say schema 'XXX' has 50 tables and i have 3 set of globalgroup users accessing this schema. Can i restrict the table select/delete/insert/update at global group level? For instance users belonging to group A should be able to create/modify/delete/insert /update table or records. Group B can only select data from all tables and groupc can select only 10out of 50 tables.is this doable? If so a user with db_owner privileges can set these up? Any input or ideas are greatly appreciated. TIA
June 12, 2013 at 9:22 am
hi,
I think it is possible.
It depends on whether your users are Windows-Users or SQL-Logins.
If Windows-Users: you can create the 3 groups you require in windows active directory and then add the 3 groups as logins on the sql server.
If the Users are SQL-Logins, you can group them together using database roles.
The next step is: give the rights you want directly on the schema XXX for each of the 3 windows logins or database roles.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply