Can a SQL login have more than one user

yousefshokati

Hello . I know that a SQL login is used to log into the server and SQL user is used to log to database but i want to know that is their a 1 to 1 correspondence between a SQL Login and SQL user or a login can have more than one SQL user that can be mapped to it. Thanks

Mycroft Holmes

yousefshokati wrote:

user that can be mapped to it.

How are you mapping a user to a login? As a SQL login consists of a user name and a password how are going to know if a user has not shared that information. We use integrated security for the developers, applications has their own sql identities and pass in the workstation id and no other connections are allowed!

Never underestimate the power of human stupidity RAH

yousefshokati

I am asking only that A SQL User (database -level security) must map to a login . It is very obvious .Now I am only asking you that can a login have more that one database-level user ? We know that a Login and a user are related with each other by SID Ok? Now i want to know that is it possible for a login , that can have nmore than one user ?

Mycroft Holmes

Ah, more context... Yes a user can have many connections, an example would be using SSMS each query window creates it's own connection using your credentials. If, in SSMS, you look at the activity monitor you will find multiple SID per login. You terminology is difficult, what do you mean by a User. A database is only interested in a connection, each connection has credentials. A set of credentials (presumably your User) may login multiple times.

Never underestimate the power of human stupidity RAH

ManishaSCode

Hi, Principals are entities that can request SQL Server resources. SQL Server Login is SQL Server-level principal A database user is a principal at the database level. One Login can be associated with many users (one per database). Thanks

https://sites.google.com/site/freelancermanisha/

Jan Steyn

:thumbsup:

rimazuc

yes an SQL login can be mapped to more than one DB user. Picture an SQL login as an access to a building while a DB user provides specific access to rooms in the building. No access to the building (Login) then no access to the rooms (DB user).