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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2002-03-04 : 13:25:10
|
| I have added an NT group and granted the group DB_Datareader and DB_Datawriter on one of our DB's. The problem is that the group is allowing the users to login and do selects however they cannot update or insert records. I granted DBO on the group for the DB and still they can only execute a select statement. If the user logins in from an NT Group do they not get the permissions from that group?RegardsDanielSQL Server DBA |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-03-04 : 13:31:18
|
| If that is their only method of access then they should get that level. However, if they are also a member of a group that has db_denydbwriter, then they will be denied that right (Same if their individual account has deny rights).Make sure rights aren't denied anywhere for any of these users.-Chad |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-03-04 : 14:08:27
|
quote:
If that is their only method of access then they should get that level. However, if they are also a member of a group that has db_denydbwriter, then they will be denied that right (Same if their individual account has deny rights).Make sure rights aren't denied anywhere for any of these users.-Chad
Ah... Now I get it. We removed some individual logins and added the Domain users group and then I denied db_datawriter on them. I then removed the login for the guy that gets update permissions and added his nt group. Because he is in the domain users group he is denied.Thanks for the help.DanielSQL Server DBA |
|
|
|
|
|
|
SQL 2k logins... Does anyone know?