SQL Server: Login & Users

[kyaqub]

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

[eduardo7095]

I believe the only way you could accomplish something like that is to add a NT group to the logins and give the NT group login access to the database. At this point, the system_user function will report the actual NT user connected to the SQL Server, granted you add the user to the NT group thru your NT security manager.

[antares686]

Ok breakdown of SQL Server logins.

A User account is created for each app or user as deemed needed. (Users of course can share the same login as number of connections is not limited per user).

A User account is granted access to a database.

Then you can either grant access for the User acount to database objects or create a Role with all the rights and put each user that should have the same acess into that Role.

This is similar to an NT user acount with rights and an NT User assigned to a Group for common accesses.


For what you are wanting create a Role with the accesses granted then as you create accounts on SQL Server and grant access to the DB, assign them to the Role you created.