应用程序用户和sqluser [英] Application user and sqluser

问题描述

我在MVC4中开发了一个Web应用程序，它是一个关于信用和融资的应用程序。应用程序一次由40到50个用户使用。应用程序报告非常繁重需要2到3分钟的生成。

我使用单个数据库用户sa

现在我想在server 2008中创建所有应用程序用户还有。

每个应用程序用户都将与自己的数据库用户连接而不是sa用户

我的问题是，这是正确的决定吗？

它会提高我的应用程序性能吗？如果不对，那我怎么能提高它的表现呢？因为40个用户使用单个用户进行报告可能需要花费更多时间而不是每个用户使用自己的数据库用户。



请急需帮助



我尝试了什么：



该怎么办？

db大部分时间处于跨国模式

I have develop a web application in MVC4 it is a application about credit and financing. Application is used by 40 to 50 users at a time. Application reporting is very heavy takes 2 to 3 minutes in generating.
I am using single db user "sa"
Now I am thinking to create all application users in server 2008 also.
Each application user will connect with own db user not with "sa" user
my question is that is It right decision?
It will increase my application performance? If it is not right then how i can increase its performance? as 40 users taking reports with single user may be take more time instead off each user taking with its own database user .

Please urgent help is required

What I have tried:

what is should do?
db is most of the time in transnational mode

推荐答案

正确的决定，绝对是的。您永远不应该让您的用户开始使用sa帐户。



而且，不，它根本不紧急。

"It right decision", yes absolutely. You should have never, ever, let your users to use the sa account to begin with.

And, no it's not urgent at all.

使用正确的用户身份验证与性能无关。在大多数情况下，无论用户登录，性能都是相同的。



在数据库中了解用户的好处是您可以定义数据库中基于用户的权限。这样您就不需要为数据库对象构建任何自定义权限处理，并且可以降低查看或修改不正确数据的风险。



一个完全不同的问题是你是怎么做到的，但是如果你了解所有用户并且在客户端有适当的登录机制，那么它是可行的。

Using a proper user authentication does not have anything to do with performance. In majority of scenarios the performance is the same regardless of the user logged in.

The benefit of 'knowing' the user in database is that you're able to define privileges on user basis in the database. This way you don't need to build any custom privilege handling for the database objects and you reduce the risk of seeing or modifying improper data.

A completely different question is, how do you do it, but if you know all your users and have proper login mechanism on the client side, then it's doable.

这篇关于应用程序用户和sqluser的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！