June 26, 2009 at 2:42 am
Dear All,
Clear Difference between Create User and Create Login .....
Is any one..
Thanks
June 26, 2009 at 3:16 am
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.
Cheers,
- Win.
" Have a great day "
June 26, 2009 at 3:58 am
Login:
Create login with password =
Which will create a login for sql server so that user can use this credentials to connect the sql server.
User:
A user is DB user which will have permission to specific or more database permissions. We can map the databases for the perticular user in the properties of user.
June 26, 2009 at 4:19 am
Agreeing to what others said, you create a login to grant access to the server as a whole and u create a User id to grant access to a database. As suggested in earlier posts, every user id must have an associated Login ID. Generally, user IDs and Logins have same name (however u can map a user id to a login which is not the same)
You see login after expanding server->security
You see users after expanding server->database->security
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply