[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How to Add Users to SQL Server database

Posted on 2012-03-21
7
Medium Priority
?
187 Views
Last Modified: 2012-06-27
How do you add users to a SQL Server Database using C#?  I want to add 5 users to a database with a domain\user format.  Thanks!
0
Comment
Question by:VBBRett
  • 3
  • 2
  • 2
7 Comments
 
LVL 7

Expert Comment

by:micropc1
ID: 37750124
execute a CREATE LOGIN/CREATE USER statement...

http://msdn.microsoft.com/en-us/library/ms173463.aspx

delete them using DROP USER

http://msdn.microsoft.com/en-us/library/ms189438.aspx
0
 

Author Comment

by:VBBRett
ID: 37750144
How do you give the user roles like DbOwner?
0
 
LVL 14

Expert Comment

by:quizwedge
ID: 37750247
You can add roles using sp_addrolemember. See http://sqlserverplanet.com/security/add-user-to-role
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 

Author Comment

by:VBBRett
ID: 37750264
And how do you specify the domain where the user is coming from given that when I add the user domain\\user I get the following error:  

I would like to add the following user:

Mycompanydomain\myuser as opposed to just myuser.
0
 

Author Comment

by:VBBRett
ID: 37750326
This is not working, especially that I am passing the query through my C# code to get this work.  Please help me find a solution so I can put this to rest.  I need the following written in C#

SqlCommand cmd = new SqlCommand("Create LOGIN " + usertobeadded + " USE " + databasename + " " +"CREATE USER " + usertobeadded + " FOR LOGIN " + usertobeadded " GO", conn);

I keep on getting with the '\' sign or the ';' sign.  What do I do?
0
 
LVL 14

Accepted Solution

by:
quizwedge earned 1500 total points
ID: 37750960
My C# is a little rusty, but I'll try. See http://msdn.microsoft.com/en-us/library/ms187750.aspx for more information. I wanted to get the information to you quickly. If below doesn't work, I'll fire up my C# environment and make sure I get the syntax right.

//Create New User
SqlCommand cmd = new SqlCommand("CREATE USER " + NameForSQL + " FOR LOGIN [" + Domain + "\" + User + "]", conn);

//Add Role
SqlCommand2 cmd = new SqlCommand("EXEC sp_addrolemember '" + Role + "', '" + NameForSQL + "'", conn);
0
 
LVL 7

Expert Comment

by:micropc1
ID: 37751007
I'm not a C# developer - I code mainly in Java - but I'm guessing it might be an issue with escaping the backslash character.

http://blog.akilles.org/2008/03/12/escaping-backslash-character-in-c-net-mysql-queries/
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question