Greetings:

Well I am little bit confused about the concept of Login and Users in Sql Server Database. The thing is that for Each user of a specific database, you have to attach that user to a specific Login to acces that database. Now if you make another user in the same database, you cannot use the same Login. So you have to make a separate new Login and attach the new user with this new Login.

Well its quite different what we can do in Oracle. As we can attach as many users as we want to a single Login.

So is there any option in SQL Server to attach more than one user to a single Login in the same database.

Regards
Khalid