I have a situation where I should create a group and create a single login for that group.For each user in the group separate schema should be created and the users cannot access schemas of each other.
Im new to SQL server can you please help me figure out how to proceed.Step by step guidance could be of great help to me.