Can anyone help me on this regarding by providing the exact code?
I need to create two Logins named (Groups) 1. Dev_S 2. Dev_T
Each Group has exactly fifty (50) Users (as Dev_S1, Dev_S2, Dev_S3 so on) in it.
How can I add these 50 users to the Groups.
Out of 50 users in each groups only 5 users needs db_datawriter rights and the rest needs db_datareader rights.
How can I grant access to these users?
Thanks in advance.