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