Hello guys I have a question
I have a group in that group a user shouldn't have syadmin permissions but he must be on that group.
He has his login map by the group and his windows login on sql server
Is it possible to deny him the server role syadmin but remain on the public role while still remain on the group?
Thanks in advance for the help.