What is the difference between login and a user?

Answer Posted / hameed

Login means authentication to server (access to MSSQLSERVER)
where as User means Login is authenticated with rights and
permissions to access the database objects (roles assigned
to Login)

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between ‘having’ clause and a ‘where’ clause?

651


How to disconnect from a sql server using mssql_close()?

688


What is an index in a database?

619


What is difference between join and natural join?

560


Explain how does the report manager work in ssrs?

592






What is trigger and different types of Triggers?

672


What is set nocount on and what is set nocount off?

593


What is the difference in accessing db between sql server vs sql azure?

161


How do you size a resultset?

589


Is it safe to delete log files?

597


What is triggers in ms sql server?

719


What methods do you follow to protect from sql injection attack?

612


What is the meaning of sql server?

617


What is tablesample?

666


What is spatial and temporal data?

620