SQL Server adds users and authorizes users

--Create user
CREATE LOGIN user name with password=n ' password ', default_database= database name, Check_expiration=off, Check_policy=off
EXEC sp_grantdbaccess N ' user name '
--Authorization
GRANT SELECT on table name to user name--add "check" permission
GRANT Insert on table name to user name--add "increase" permission
GRANT Update on table name to user name--add "change" permission
GRANT Delete on table name to user name--add "delete" permission

SQL Server adds users and authorizes users