AZR.IR Home Short Notes About Login   

CREATE LOGIN Login_Name WITH PASSWORD = 'mySecretPass';  
CREATE USER  User_Name  FOR LOGIN Login_Name;