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

can a database be shrunk with users active? : Sql server administration

950

Explain encryption of entire databases without the need for application changes in sql server 2008?

994

What is ddl and dml commands?

848

What is compression - row-level and page-level compression?

863

What happens if you delete a table that is used by a view?

941

What are the types of processing and explain each? : sql server analysis services, ssas

1105

Can you please differentiate between a primary key and a unique key?

949

Which language is supported by sql server?

954

What are relationships and mention different types of relationships in the dbms

911

What is transactional replication?

902

How do I find the size of a sql server database?

876

what are the important architecture components of SSRS?

124

How to declare a cursor with "declare ... Cursor" in ms sql server?

978

How does index makes search faster?

919

What stored by the model? : sql server database administration

899