A login defines access privillege to the SQL Server. A user defines the a

What is the difference between login and a user?

Question Posted / peter jacob

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

Please Help Members By Posting Answers For Below Questions

what is a transaction? : Sql server database administration

994

What are data files?

1042

How to filter records of table in SQL SERVER?

1086

Tell me extended events in sql server 2008?

997

How to connect sql server management studio express to sql server 2005 express?

1042

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1006

Will sql server 2005 allow you to reduce the size of a column?

992

What is a View ? Can we insert, Update and delete a view?

995

What is the difference between dropping a database and taking a database offline?

1174

How does clustered and non clustered index work?

925

How to create indexed view?

1045

When would you use a before or after trigger?

908

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

971

Can binary strings be used in arithmetical operations?

937

How do you create type- insensitive operator?

1045