Today's one of my colleagues want to
create new database login. He was trying to create a new use on a particular
database. Because he is being confused about what is different between Login and
User account. Here I am clearing his doubt and explain the difference between
Login account and User account in SQL Server
-
A login is used for SQL Server authentication
-
A user
account is used for database access and permissions validation.
Real Time Example
In shopping mall have a
main entry point, if you lock the main point you cannot access/open the any shop
inside the shopping mall. This main entry point in SQL Server called Login to
access the SQL Server. Inside the shopping malls each shop has own lock.
Particular shop access in SQL Server called the User account. User we can define
for particular database, because we have multiple databases with in single
database server.
![Image1.jpg]()