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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-08 : 08:24:13
|
| Varghese writes "My SQL Server is using Windows Authntication and have around 30 Db's on this server. Recently the network team decide to change few NT Ids, is there any way to sync to my new Id rather than me changing manually.If drop the old one and add new one I will lose the the prior security set on database. Any suggestions wouuld be great.Example.Domain/JDoe ==>Domain/JDoe02" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-08 : 08:29:24
|
| First off, don't drop the old login, at least not until you've got the new one set up with the proper permissions.You can use sp_helprotect to list the permissions your old login has, and reformat its output to generate the GRANT/REVOKE/DENY statements needed to apply them to the new one. It sounds like more work than it really is.It would be worth considering roles for your databases, and doing all the permissions through them instead. Then you simply add users to the appropriate roles and you're done. Even if there's only one person in the role, it's just as much work to set up and a lot less hassle in situations like yours. |
 |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-06-08 : 09:24:15
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50815If you're not satisfied with the response you get, add to the existing thread with a request for additional ideas. Don't re-post a duplicate topic.Be One with the OptimizerTG |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-06-08 : 12:24:32
|
| Ahhhh, that's the moderator's fault (me) for not picking up the registered post. |
|
|
|
|
|
|
NT Login Id changes Sync to SQL Server Security