Create user and assign permission to user in LocalDB in Visual Studio

c# visual-studio localdb
SP1 picture SP1 · Sep 16, 2015 · Viewed 15.5k times · Source

Can someone please tell me how I can create a user with a password and grant it owner permission to a database that I created in LocalDB in Visual Studio.

It creates a user with no login but I need to create one with a password and owner rights to a database.

Answer

ngm picture ngm · Jan 8, 2016
  • Open SQL Server Object Explorer (e.g. from the Visual Studio View menu)
  • Expand your localdb instance in the tree (e.g. (localdb)\MSSQLLocalDB)
  • Right click your database and select New Query...
  • Execute the following sql:

...

CREATE LOGIN [SomeUser] WITH PASSWORD = 'topsecret';
CREATE USER [SomeUser] FOR LOGIN [SomeUser];
exec sp_addrolemember 'db_owner', 'SomeUser'

Related questions

LocalDB not recognized in Visual Studio 2015

I'm trying to create a database-first ASP.NET MVC app with Entity Framework in Visual Studio. Starting with a blank project template, I open up the Server Explorer and try to add a data connection. I use Microsoft SQL Server …

Read More
Code-First approach, location of database and all instances (v110, etc)

I'm following this tutorial to create a Code-First Database. After installing EF and creating those first basic classes it says: Run your application and you will see that a MigrationsCodeDemo.BlogContext database is created for you. Well, I have VS2013 …

Read More
How do I remedy "The breakpoint will not currently be hit. No symbols have been loaded for this document." warning?

A C# desktop application on the express edition worked, but then it didn't work 5 seconds later. I tried the following: Ensure debug configuration, debug flag, and full debug information are set on all assemblies. Delete all bin and obj folders …

Read More