To set the DBO schema for a SQL Server server

The server login name , which is the user who has permission to log on to a server;

server Role , a fixed set of server users, the default is 9 groups;

• Logins must belong to some roles, default to public

• Server roles are not allowed to change

• Does not necessarily have permission to manipulate the database after logging on

database user , refers to the user who has permission to operate the database;

A database role , which is a fixed set of database roles with certain permissions;

database schema , which refers to the container of database objects;

• The database user corresponds to the server login so that the logged-on person can manipulate the database

• Database roles can be added and different permissions can be customized

• Database schemas, similar to the namespace of database objects, where users Access database objects through schemas

And by allowing these concepts to be clear:

　　　　

The above content is reproduced in sima2004 's Blog

First step: Create a new login name

Part II: Creating a new Database

Step Three: Mydb-->security-->schema-->new Schema

Fourth Step: Mydb-->security-->users-->new User

Fifth step: Set the user mapping of the login name

Log in with the new login mas, create the table Taba,

According to the above method, new schema Schema2, login name mas2, user name User2

Log in with the new login name MAS2 to create the table Taba.

Dbo. Taba is created by the sa login name

Myschema.taba is created with the MAS login name

Myschema2.taba is created by the MAS2 login name

To set the DBO schema for a SQL Server server