June 2, 2008 at 4:54 pm
Somehow my company does not want to do window authentication. So we use SQL Server security right now. However my boss wanted to have a user group liked the window user group, so if he wanted to change the security of all the databases in all the servers (there are over 60 databases over 20 servers), he just needed to change the group.
I thought in order to change the SQL Server security, you need to change every database in all the servers.
June 3, 2008 at 7:25 am
You can't create a group per se, but you could create a role and assign individual sql logins to be members of that role, coming "close" to the desired effect of a "group". Having permissions/rights assigned to that role and changing those permissions/rights would thus affect every sql login, but you are correct in that this would need to be done on each server, not like a Windows group that could be changed in AD and you're done.
The change across all servers/databases could be handled in an automated way with a batch file using osql/sqlcmd, and how complicated that is kind of depends on what changes are needed.
"Got no time for the jibba jabba!"
-B.A. Baracus
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply