How to set permissions to multiple SQL users at once?

In order to Grant permission to multiple users, we have to create Role and add the users to that role.


Create Role Role_Multiple_User_Permisisons
Go
Alter Role Role_Multiple_User_Permisisons add member User1
Alter Role Role_Multiple_User_Permisisons add member User2

Grant CONTROL on Object to Role_Multiple_User_Permisisons

• Tweet
• Share
• Share
• Share
• Share