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 sql server replication? : sql server replication

1031

What specific conditions database should meet, before you can bulk copy data into it using bcp?

1037

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

1088

What is the difference between char, varchar and nvarchar?

1071

Write an sql query for deleting duplicate rows?

1034

When you should use a low fill factor?

1033

What is the difference between TRUNCATE and DROP?

1182

How to create function without parameter in sql server?

1101

What is a document index?

1068

How to create prepared statements using odbc_prepare()?

1097

Do you know what is sql injection?

1036

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1049

whats new about truncate in sql server 2008?

2549

If user is owning any SQL Objects, can we drop that user

2127

How can you start sql server in different modes?

1017