What is the difference between login and a user?

Answer Posted / prasad

Login is for Entire SQL server Instance,
User is for particular database.

1 login=many users.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to turn on the mssql api module in php?

665


What are the types of user defined functions in sql server?

595


When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

751


What is the difference between sdf and mdf?

835


How to enter binary string literals in ms sql server?

704






How to populate a table in sql server?

592


How do you manipulate data?

587


what is a join? : Sql server database administration

640


what is sql server? : Sql server database administration

606


What is Command line parameters in PLSQL.?

660


Tell me something about security and sql azure?

110


What is schemabinding a view?

614


What does the on delete cascade option do?

656


What is the difference between stored procedure and user defined functions?

722


Explain security with sql azure?

165