1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the difference between login and a user?

Question Posted / mirjawad

Answers were Sorted based on User's Feedback



What is the difference between login and a user?..

Answer / laxman

Login is to connect sql server & user is connect individual
db in server.
every db user will maped with login.

Is This Answer Correct ?    30 Yes 1 No

What is the difference between login and a user?..

Answer / visala

login is server level and user is database level.

Is This Answer Correct ?    25 Yes 1 No

What is the difference between login and a user?..

Answer / dharmendra k. dixit

Login is the way of authentication into MSSQLServer,
and Users are the members of that Authentication as per
their Access rights for a specific DataBase.

Is This Answer Correct ?    20 Yes 1 No

What is the difference between login and a user?..

Answer / peter jacob

A login defines access privillege to the SQL Server. A user
defines the accessible objects and rights the login has.

Is This Answer Correct ?    18 Yes 4 No

What is the difference between login and a user?..

Answer / sivakumar

Login is authentication into server level
And Users is authentication into object level.

Is This Answer Correct ?    14 Yes 2 No

What is the difference between login and a user?..

Answer / hameed

Login means authentication to server (access to MSSQLSERVER)
where as User means Login is authenticated with rights and
permissions to access the database objects (roles assigned
to Login)

Is This Answer Correct ?    5 Yes 0 No

What is the difference between login and a user?..

Answer / siva

login is server level and user is Object level.

Is This Answer Correct ?    6 Yes 4 No

What is the difference between login and a user?..

Answer / potula

login defines access privillege to sql server. A user
defines the accessible objects and rights the login has

Is This Answer Correct ?    4 Yes 2 No

What is the difference between login and a user?..

Answer / sky

A login without a DB User will not have access to the
database or will access to only databases that have built
in Guest users created (by default, guest users are present
in Master & MSDB DB). DB User without a SQL Server login is
not possible. Each DB User must be related to a SQL Login.

Is This Answer Correct ?    2 Yes 0 No

What is the difference between login and a user?..

Answer / nidhi shah

A SQL Server login allows a user to connect to a server. A
login is the base concept.

Database user is associated with a login to allow specific
permissions on that database.



DB user without SQL Server login: not possible to create, a
Database User MUST be
related to a SQL Server login.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Give main differences between "Truncate" and "Delete".

1 Answers   HCL,

How to filter out duplications in the returning rows in ms sql server?

1 Answers  

create index a on employee(dno) In this,which index was created?

2 Answers  

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1 Answers  

how to do partition in sqlserver

1 Answers   TCS,

What is database mirroring?

1 Answers  

How are SQL Server databases physically stored under Windows 2000?

1 Answers  

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

Are resultset updatable?

1 Answers  

What is exclusive locks?

1 Answers  

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

For more SQL Server Interview Questions Click Here
Categories