July 21, 2009 at 4:28 am
I have a very simple question.
I have a group of users to be granted access to a specific db through windows Auth.
They should just be given DML access, and denied DDL access.
I have so far just created them as users under this db, using their id of the form domain]username, then created a database role with db_datareader, db_datawriter permissions and added all of them to this role.
However, they still seem to have trouble with access.
Can anyone let me know what is the problem?
July 21, 2009 at 4:43 am
Follow these steps
1. Ask your domain admin to create a windows group and and all these users to that group.
2. Create a login in sql server for this group.
3. Grant connect privilege to this group
4. Create a database level user and grant this user db_datareader and db_datawriter permissions.
Can you post the errors here and what are the issues they are facing . Did you check out the sql error log.
[font="Verdana"]Thanks
Chandra Mohan[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply