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 |
|
mohsinali78
Starting Member
1 Post |
 Posted - 2008-11-18 : 06:47:21
|
| Hello Everyone,In my project (which i recently inherited) user rights have been assigned on the Active directory group; I mean if there's group called ABC_Users in AD, I've created the same group under Security/Logins) users are given 'ProcessAdmin' roles on the group.I've two questions:1- It has happened that (sometimes) a user does soemthing and that removes the rights from the database, can you guess what it can be?2- After the above problem happens, even if i reassign the group to that database, it allows users to connect but as soon as they link the tables it throws the error 'SQL Server Link Terminated' and it comes out.I tried my best but it didnt work until I gave them the 'SysAdmin' rights and then it started working. As per the rule, am not supposed to give them 'SysAdmin' rights.Plz give your thougths on it.ThanksMohsin |
|
|
|
|
|
Active Directory Group Rights Issue