T-SQL：创建登录用户数据库用户...

 创建登录用户

 

CREATE LOGIN loginName { WITH <option_list1> | FROM <sources> }<option_list1> ::=     PASSWORD = { 'password' | hashed_password HASHED } [ MUST_CHANGE ]    [ , <option_list2> [ ,... ] ]<option_list2> ::=      SID = sid    | DEFAULT_DATABASE = database        | DEFAULT_LANGUAGE = language    | CHECK_EXPIRATION = { ON | OFF}    | CHECK_POLICY = { ON | OFF}    | CREDENTIAL = credential_name <sources> ::=    WINDOWS [ WITH <windows_options> [ ,... ] ]    | CERTIFICATE certname    | ASYMMETRIC KEY asym_key_name<windows_options> ::=          DEFAULT_DATABASE = database    | DEFAULT_LANGUAGE = language

创建数据库用户

CREATE USER user_name     [ { { FOR | FROM }      {         LOGIN login_name         | CERTIFICATE cert_name         | ASYMMETRIC KEY asym_key_name      }       | WITHOUT LOGIN    ]     [ WITH DEFAULT_SCHEMA = schema_name ]

删除登录用户

DROP LOGIN login_name

删除数据库用户

DROP USER user_name

授权给数据库用户

Simplified syntax for GRANTGRANT { ALL [ PRIVILEGES ] }      | permission [ ( column [ ,...n ] ) ] [ ,...n ]      [ ON [ class :: ] securable ] TO principal [ ,...n ]       [ WITH GRANT OPTION ] [ AS principal ]