使用数据库登录身份验证 [英] Authentication using Database Logins
问题描述
我有点新的ASP.NET MVC和我希望你可以帮我验证了我的应用程序。
I'm somewhat new to ASP.NET MVC and I hoped you can help me with authentication for my app.
我有一个需要使用SQL Server登录插件进行验证MVC应用程序。这意味着我必须建立在SQL Server中的角色和用户，以及所有安全权限在数据库级管理。角色，用户和权限不是恒定的，我们应该能够管理它们。
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.
任何建议？反正是有覆盖身份默认行为来实现这一目标？你认为是实现这一需求的最佳方式？我应该使用AD或DB登录都很好？
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? Should I Use AD or DB Logins are fine?
在此先感谢
推荐答案
根据与不同的登录机制我的工作经验，我想建议你以下路线
Based on my working experience with diverse login mechanisms, I would like to suggest you the following route
- 选择AD作为您的身份提供者[IDP]
- 注册您的应用程序作为信赖方[RP]
- 从AD获取联邦元数据来设置你的应用程序
- 在情况下，你有ADFS 3.0 AD服务器，请参阅本的为样本链接
- 在通过OWIN联邦中间件去的情况下，它应该如本<给定对您很少开发工作非常容易href=\"http://leastprivilege.com/2014/02/21/test-driving-the-ws-federation-authentication-middleware-for-katana/\"相对=nofollow>链接
- Choose AD as your identity provider[IDP]
- Register your application as an Relying Party [RP]
- Get the federation metadata from AD to set up your application
- In case you have your AD Server with ADFS 3.0, refer this link for a sample
- In case of going through the OWIN Federation Middleware, it should be very easy for you with little development effort as given in this link
使用ASP.Net MVC5＆安培; Owin你这个任务应该是小菜一碟
With ASP.Net MVC5 & Owin this task of yours should be a piece of cake
对于基于Azure的AD采样，请参阅这里或第一手的信息，请阅读<一个href=\"http://www.cloudidentity.com/blog/2013/07/30/securing-a-web-api-with-windows-server-2012-r2-adfs-and-katana/\"相对=nofollow>这个文章
For Azure AD based samples, refer here or for first hand information, read this article
这篇关于使用数据库登录身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
