Solved

How to Add Users to SQL Server database

Posted on 2012-03-21
7
179 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

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 500 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Service Controller 1 28
MediaHelp 4 26
Amazon S3 .Net error 5 21
C# Linq - Join two objects into one 3 16
Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

820 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