Multi-user use the database at the same time

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.