creation of userid with rights equal to sa login

• Jai-448139

  SSC Eights!

  Points: 818

  More actions

  September 10, 2007 at 10:10 pm

  #197708

  Hi

  can anyone help me with the script for creation a new userid similar to sa

  rights . all the rights should be similar to sa. just to have two userid's for with sa rights.

  Thanks

   

   

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  September 11, 2007 at 9:41 am

  #732842

  Just make the new login a member of the sysadmin fixed server role.  We make the DBAs members of sysadmin so they can do all the SQL Server administration using they're domain logins.  Sa is never used.

  Greg

  Greg

• Jai-448139

  SSC Eights!

  Points: 818

  More actions

  September 13, 2007 at 1:36 am

  #733390

  thanks greg

• Venkatesan Prabu

  SSCommitted

  Points: 1892

  More actions

  September 14, 2007 at 12:18 am

  #733672

  You have asked for code snippet right below is the code sir

   

  USE

  [master]

  GO

  CREATE

  LOGIN [vp] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

  GO

  EXEC

  master..sp_addsrvrolemember @loginame = N'vp', @rolename = N'sysadmin'

  GO

  USE

  [master]

  GO

  CREATE

  USER [vp] FOR LOGIN [vp]

  GO

  "vp" is the user created with windows authentication

  Regards,

  Venkatesan Prabu. J

  Thanks and Regards,
  Venkatesan Prabu,
  My Blog:

  http://venkattechnicalblog.blogspot.com/

• Jai-448139

  SSC Eights!

  Points: 818

  More actions

  September 14, 2007 at 2:54 am

  #733692

  thankyou venkat