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 purpose does the model database serve? : Sql server database administration

505


What is temporal table?

481


What are SSL and TSL protocols?

585


What is a virtual table in sql?

549


How you can minimize the deadlock situation?

554






Describe the left outer join & right outer join. : sql server database administration

584


What does set rowcount do?

512


What is user-defined functions? What are the types of user-defined functions that can be created?

566


What does the update command do?

615


How to execute a stored procedure in ms sql server?

552


What is meant by referential integrity?

591


Can you pass expressions to function parameters?

541


What are subqueries in sql server? Explain its properties.

544


What is reference section?

497


Do you know the cursor types?

619