What is the difference between login and a user?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can a database be shrunk with users active? : Sql server administration

563


How do you delete a data source?

540


What does the automatic recovery do?

573


What is difference between after and before?

502


In which tcp/ip port does sql server run? Can it be changed?

540






Give the query of getting last two records from the table in SQL SERVER?

535


What is cdc in sql server?

568


List down some advantages of sql stored procedure?

552


What is a benefit of using an after insert trigger over using a before insert trigger?

507


What is the purpose of sql profiler in sql server?

509


Can coalesce return null?

542


Do you know what are the properties of the relational tables?

573


Do you know the different ddl commands in sql?

589


Why truncate is ddl command?

512


Can group by be used without aggregate functions?

477