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

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

534


Explain log shipping?

589


Explain sql delete command?

615


What is sql server english query?

547


What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

692






What are the limitations/drawbacks or ssrs 2008 r2?

86


What is normalization? Explain its different types?

606


Can sql servers linked to other servers like oracle?

548


How do I shrink an ldf file?

572


What is trigger in salesforce?

502


What is cube dimension? : sql server analysis services, ssas

538


What are the types of joins in sql?

563


How to change the system date and time from SQL Plus Terminal ?

689


What is star, snowflake and star flake schema? : sql server analysis services, ssas

665


What is the openxml statement in sql server?

538