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

Explain transaction server distributed transaction?

596


What is xdr?

668


What is the report model project?

109


How will you monitor replication latency in transactional replication? : sql server replication

706


In how many ways you can invoke ssrs reports?

111






what is the different types of backups available in sql server? : Sql server database administration

581


Can we use pragma autonomous_transaction in trigger?

631


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1725


What causes index fragmentation?

673


What is difference between rownum and rowid?

596


What are the approximate numeric data types?

616


What are the different types of upgrades that can be performed in sql server?

801


What is user defined stored procedures?

648


How do I open a .db file?

583


What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

702