Last post Apr 01, 2015 01:44 AM by Archer Wang
Mar 27, 2015 10:53 PM|Akbari123|LINK
I'm somewhat new to ASP.NET MVC and I hoped you can help me with authentication for my app.
I have a MVC application that needs to be authenticated using SQL Server Log Ins. This means I have to create roles and users in SQL Server, and all security permissions are managed at Database level. Roles, users, and permissions aren't constant and we
should be able to manage them.
Any suggestion? Is there anyway to override default behaviors of Identity to achieve this goal? What do you think is the best way to implement this need?
Thanks in advance
Mar 30, 2015 02:40 AM|Archer Wang|LINK
As I know, if you use Role Management, it doesn't need store roles into database. Do you mean you want to authenticate users without database? If so, you could use Forms Authentication Credentials. For more information, please refer to the below link.
However, when you want to add new users, this way is hard to add. I suggest that you could use ASP.NET Identity with MVC. Please check the below article.
Hope this could be helpful to you.
Mar 31, 2015 04:01 AM|Akbari123|LINK
Apr 01, 2015 01:44 AM|Archer Wang|LINK
As I know, it may not possible that each user uses its own database logins.
So I thought instead of using Identity's default behavior and defining tables for users and roles I can use database commands to create database logins and roles.
This situation also may not possible. I suggest that you could build different tables for different users, and different roles have different permission could access different tables.
We connect the database by the certain user and password, we set this information at the connection string. So, it is hard to achieve this. However, you could set different connection string with different databases for different users.