How can we make default schema for any user on a specific database? So that user will work
on that schema only it is more securable than without schema.
We can assign specific schema to specific user. Let’s see how can we do that?
Go to Database ==> Security ==> Users ==> Double click on user name
We will get one window wherein we need to set all values. Following screen will come
once we will click on user name.
Here you can assign default schema name.
That’s It.
Enjoy Learning.
No comments:
Post a Comment