SQL Server Insert User

' Create login User

Use master

Create login [Mashenghao] with password= ' Kline ',
DEFAULT_DATABASE=[KCHNETDB], Default_language=[us_english], Check_expiration=off, Check_policy=off

' The following can create a user for a different database

Use Kchnetdb

' Create database login user for login user

Create user [Mashenghao_kchnetdb] for login [Mashenghao]

' Set schema

Alter user [MASHENGHAO_KCHNETDB] with default_schema=[dbo]

' Create a new schema

CREATE SCHEMA [Mashenghao_schema] AUTHORIZATION [MASHENGHAO_KCHNETDB]

' Set the operation role of the database user (Operation permissions)

EXEC sp_addrolemember n ' db_datareader ', n ' mashenghao_kchnetdb '

EXEC sp_addrolemember n ' db_datawriter ', n ' mashenghao_kchnetdb '

You can now open SQL Studio to log into the database with Mashenghao and create a new query

SQL Server Insert User