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
Why do we use stored procedures in sql server?
List out what other servers you can use with ssrs?
role of sql sever 2005 in database rather than any other database
What are the database roles? : sql server security
Does a full backup include transaction log?
Explain what are various ways to enhance the ssrs report?
how you can deploy an ssrs report?
Is sql server difficult to learn?
Explain what are commit and rollback in sql?
What is the usage of sign function?
What new changes are being made in SQL Server?
What is meant by dirty read?
What are the different types of backups that exist?
What do you understand by SQL*Net?
What does set rowcount do?