What is the difference between login and a user?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which rendering formats are affected by the pagesize properties?

106


What is difference between after and before?

506


What is correlated subquery in sql server?

559


How do I view views in sql server?

518


What is identity?

555






What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

550


Can we store videos inside the sql server table?

519


Tell me what is fill factor?

555


Explain try...catch with sql server?

598


Can group by and orderby be used together?

596


What are the different types of subquery?

616


what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

497


What is stretch database in sql server?

567


What is a field name?

514


What are user defined functions in ms sql server?

510