Bhaskar Shelar

Bhaskar Shelar

  • 1.7k
  • 42
  • 2.6k

Creating new schema as new user register to Portal SQL Serve

Feb 19 2018 2:04 AM
Thanks in advance actually I am looking for : when any new user is registering in my system(web portal) I have to create a separate database schema for respective user . For example when I registered new user named Bhaskar for that I have to use existing table structure but it can only be accessible by using select * from bhaskar.users ,select * from bhaskar.documnetdetails & rest all the tables such a table data should be accessible(insert/update/delete) only which Bhaskar is creating/modifying or deleting
I am looking something like above mentioned so that I can able to show only respected data other than master table will be accessible to that users.

Answers (1)