Sqlserver related, sqlserver

Sqlserver related, sqlserver

Sqlserver is a medium-sized database between oracle and mysql.

Definitions of SQL Server users and roles are very different from those of mysql and oracle.

First, there are login names and server roles (8, which cannot be changed ).

Then, each database has a user name and a database role. Each user name corresponds to a scheme, that is, the architecture.

The two are related. The former is used for logon, and the latter is used for database management.

The default windows user is the default login name of sqlserver. Then there is a defined sqlserver login name, which has sa by default. This user has the default Management permission. The new login name is a public role (you can view any database ).