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 can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1221


how to do partition in sqlserver

1974


what is a self join? Explain it with an example? : Sql server database administration

502


Can the “if update (colname)” statement be used in a delete trigger?

559


What do you mean by an execution plan? Why is it used? How would you view it?

534






What is RMS migrations?

1711


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

534


What security features are available for stored procedure?

593


How do I create an extended event in sql server?

495


How to get the definition of a user defined function back?

571


How do I view a stored procedure in sql server?

523


When a primary key constraint is included in a table, what other constraints does this imply?

603


What is sql server profiler?

574


Explain log shipping and mention its advantages.

600


What do you understand by triggers?

528