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

Disadvantages of the indexes?

591


Why functions are used in sql server?

510


Explain acid?

615


What is difference between drop truncate and delete?

558


What is difference between line feed ( ) and carriage return ( )?

528






how can u get last observation in an unknown dataset ?

2003


What is meant by dirty read?

560


Explain for xml explicit mode?

570


What is entity data services?

580


What is the template in sql?

539


Explain trigger and trigger types?

559


What are the different authentication modes in sql server?

579


What is database white box testing?

680


What stored by the tempdb ? : sql server database administration

570


what is the system function to get current user's user id? : Sql server database administration

554