User
****

Create
======

From *S*, you can create new db users easily with the following script.

Run the script against the target database after replacing ``@@user`` with
the required username and ``@@password`` with the password:

::

  CREATE LOGIN @@user WITH PASSWORD=N'@@password', CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
  GO
  ALTER LOGIN @@user ENABLE
  GO
  CREATE USER @@user FOR LOGIN @@user WITH DEFAULT_SCHEMA=[dbo]
  GO
  EXEC sp_addrolemember 'db_owner', '@@user'
  GO
  EXEC sp_addrolemember 'db_datareader', '@@user'
  GO
  EXEC sp_addrolemember 'db_datawriter', '@@user'
  GO