What is the difference between login and a user?

Answer Posted / nidhi shah

A SQL Server login allows a user to connect to a server. A
login is the base concept.

Database user is associated with a login to allow specific
permissions on that database.



DB user without SQL Server login: not possible to create, a
Database User MUST be
related to a SQL Server login.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use stored procedures in sql server?

499


List out what other servers you can use with ssrs?

93


role of sql sever 2005 in database rather than any other database

1514


What are the database roles? : sql server security

566


Does a full backup include transaction log?

485






Explain what are various ways to enhance the ssrs report?

572


how you can deploy an ssrs report?

127


Is sql server difficult to learn?

527


Explain what are commit and rollback in sql?

534


What is the usage of sign function?

598


What new changes are being made in SQL Server?

578


What is meant by dirty read?

560


What are the different types of backups that exist?

684


What do you understand by SQL*Net?

617


What does set rowcount do?

516