WindowsServer Local group has been renamed ...
-
A WindowsServer Local group has been renamed.
This group had been granted authority on the SQLServer.
Within SQLserver I can only see the old windows-groupnames. (they are stored in sysxlogins).
Are there any sp/xp with which I can refresh the group-usernames or should I messup the systemtable manualy ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Don't do that.
Grant the new windows local group with EM or sp_addlogin.
-
On the other hand, I cannot prevent it !
I can tell my windows-group-administrators, but that is as good as a flyer. You spread the message, but you don't know if anyone takes it into account.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I guess you could update the table manually, but I hate to do that. I'd add the new group and drop the old one.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply