Application user and sqluser

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

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

Posted 27-Oct-16 23:45pm

tanvirvision

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

NotPolitcallyCorrect · Answer 1 · 2016-10-27T23:59:00

Solution 1

"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.

Posted 27-Oct-16 23:59pm

NotPolitcallyCorrect

Updated 28-Oct-16 0:14am

v2

Wendelius · Answer 2 · 2016-10-28T03:38:00

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.