1.SQLServer login
1.1SQlServer three-tier security management mechanism
includes login name, database, operation database permissions
a login name Corresponding to multiple database users, belong to one-to-many; one database user corresponds to one database, belong to one-to-one
1.2 login name (login account)
is used to log in to the SQL Server database server ; A database server may have several databases
1.3 database users
is used to access the specified database. After the login is successful, find the corresponding database user according to the login name, and then visit a specific user database. Find the corresponding authority of the database user, operate the database
2. Add a login account
The login account sa is the super administrator account, has the highest authority for database management, and can manage all databases , Automatically created during installation
1 use master
2 go
3 exec sp_addlogin 'YangSan','1001'
4 --The account name is "YangSan", the password is "1001", separated by commas
Add SQLServer account
1 use master
2 go
3 exec sp_addlogin 'YangSan','1001'
4 --The account name is "YangSan", the password is "1001", separated by commas
Add SQLServer account
1 use master
2 go
3 exec sp_addlogin 'YangSan','1001'
4 --Account name is "YangSan", password is "1001", separated by commas