Creating ASP.NET Identity user using SQL

Question

In our ASP.NET MVC Core app we are using ASP.NET Idenity to implement user management.

Question: Instead of using ASP.NET user interface, how can we directly create a user into the SQL Database (using a SQL statement etc.)? Will creating a user directly in ASPNETUsers table cause any issue? Note: We need to populate built-in identity table ASPNETUsers from a list of users. Password can be anything and no specific role is required.

Have you tried? What happened when you tested this?

dfundako
– dfundako

2017-01-06 20:47:31 +00:00
Commented Jan 6, 2017 at 20:47 — dfundako
– dfundako, Commented Jan 6, 2017 at 20:47

Michael Wheeler · Accepted Answer · 2017-01-26 20:59:42Z

8

Here is the insert script for AspNetUsers

INSERT [dbo].[AspNetUsers] ([Id], [AccessFailedCount], [ConcurrencyStamp], 
[Email], [EmailConfirmed], [LockoutEnabled], [LockoutEnd], [NormalizedEmail], 
[NormalizedUserName], [PasswordHash], [PhoneNumber], [PhoneNumberConfirmed], 
[SecurityStamp], [TwoFactorEnabled], [UserName]) VALUES 
(N'0633e088-30a6-444f-9603-70d7c26748ef', 0, 
N'd2feada1-c7db-4f5a-801c-4ae5c990a49d', N'[email protected]', 1, 1, NULL, 
N'[email protected]', N'[email protected]', 
N'AQAAAAEAACcQAAAAEBqhdvkH3O3glua9IFU+LDamc3mj03dPQ/8brAW34GTN6kxMOqs5je90FNn7fuNleQ==', 
N'+10001234567', 1, N'6123adf0-fc53-4abb-b6a4-52d164da4e4f', 0, N'[email protected]')
GO

Of course you will need to generate your own Guids and hash your own password.

answered Jan 26, 2017 at 20:59

Michael Wheeler

2,5173 gold badges19 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ali EXE Over a year ago

How can I create password hash? Can I copy from my local to the server?

Collectives™ on Stack Overflow

Creating ASP.NET Identity user using SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related