Creating new schema as new user register to Portal SQL Serve

This is complex and simple, depending on how you look at it.

 

As a part of use registration, you should be able to connect the db with user which has priviledges to create a schema and then create user, create schema and then disconnect. Then connect back again with newly created user. This is all that should happen dynamically.

 

Also schema names are unique and are restricted by SQL Server object naming restrinctions. How do you plan to enforece them. What if another bhaskar registers, what if 5-6 bhaskars register. You need to be ready for such scenarios.