User creation query thourgh MS SQL SERVER Mgmt Studio

• Sujith-400449

  Grasshopper

  Points: 14

  More actions

  January 23, 2007 at 11:15 pm

  #171933

  HI everybody...

  Can anyone help me to know the

  Query to Create SQL database Users in MS SQL

  through the query engine of MS SQL Server Management Studio..

  I am struggling with the same and I tried the one

  create user <user_name> for login <login_name>.

  But it seems that it will create the windows user itself and not the sql user.

  Please help me in this situation.

  Thanks in advance

• James Moore (Red Gate)

  SSCrazy

  Points: 2644

  More actions

  January 24, 2007 at 2:28 am

  #685144

  Hi there,

  You want somthing like:

  CREATE LOGIN James

  WITH PASSWORD = 'Kjskd*&sd^^54665&';

  USE AdventureWorks;

  CREATE USER James FOR LOGIN James;

  GO

  The sytax is documented here:http://msdn2.microsoft.com/en-us/library/ms173463.aspx

  Hope this helps,

  - James

  --
  James Moore
  Red Gate Software Ltd

• Sujith-400449

  Grasshopper

  Points: 14

  More actions

  January 24, 2007 at 3:01 am

  #685147

  Actually I want something similar to the following thing which is acually used in ORACLE for user creation.

  created user <user_name> identified by <password>

  Same stuff I want for MS SQL also