TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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.
Reply
Answers (
1
)
Index Fragmentation?
How to insert data into two related tables?