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
how to do partition in sqlserver
What authentication modes does sql server support?
How do you delete a trigger?
What is buffer cash in sql server?
List the types of recovery model available in sql server?
Explain sql server service broker?
How to concatenate two strings in SQL Server.
What is tempdb in sql server?
What is difference between drop truncate and delete?
What is right outer join in sql server joins?
What is the concept of optimization?
What is the default schema of your login session in ms sql server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is data source object?
Explain about nested stored procedure?