Multi-user use the database at the same time(HOW)

Question

Post reply

Multi-user use the database at the same time(HOW)

Siavash.B

Valued Member

Points: 62
More actions
August 12, 2023 at 9:07 am

#4259342

When we have multiple users, What's the best way connect(logging, query on tables,...) to database?
Which is better and why?
1) Create users(DB User) in the SQL Server for each user(Windows App User).
2) Create a table which is fill with all App user and just connect to SQL Server with a user and query on that table.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80330 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.

andreas.kreuzberg SSCertifiable Points: 6191 More actions · Answer 2

Hy,

sorry, but I don't understand your question.

The sql server is able to handle a lot of connetions in the same time.

It only depends on your database, the query and a lot of other dependencies, wether your sql server is able to handle x connections at the same time.

Maybe you should discribe your question with some more details.

Kind regards,

Andreas

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

Generally, we would create a group within Windows security, give that group access to the database, then add or remove users from the group. That way, we didn't have to touch the database or the server to administer security.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1004376 More actions · Answer 4

I totally agree with Grant. IMHO, what he's recommending (AD Groups a.k.a. Active Directory Groups) is the only way to go on something like this.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)