What is the difference between login and a user?

Answer Posted / potula

login defines access privillege to sql server. A user
defines the accessible objects and rights the login has

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How sql server executes a statement with nested subqueries?

511


Explain the xml support sql server extends?

621


what is blocking? : Sql server database administration

502


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1330


How can I add Reporting Services reports to my application?

91






What is the difference between a "where" clause and a "having" clause?

615


Can we deploy SSRS reports on our personal website?

123


What is sql service broker?

586


Will the writetext statement activate a trigger?

571


How to view the error log for any specific instance? : sql server database administration

579


Do you know sql server 2008 backup compression?

564


What programming language would you use to create embedded functions in ssrs?

122


What are the restrictions applicable while creating views? : SQL Server Architecture

584


What is database black box testing?

605


How to Check if table exists in sql server?

617