Post reply

creation of userid with rights equal to sa login

  • 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

     

     

  • 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

  • September 13, 2007 at 1:36 am

    #733390

    thanks greg

  • 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/

  • September 14, 2007 at 2:54 am

    #733692

    thankyou venkat

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply