Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Difference between Create User and Create Login .....♀§♀§♀§ Expand / Collapse
Author
Message
Posted Friday, June 26, 2009 2:42 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:19 AM
Points: 1,202, Visits: 1,933
Dear All,

Clear Difference between Create User and Create Login .....

Is any one..


Thanks

Post #742464
Posted Friday, June 26, 2009 3:16 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, March 29, 2012 5:22 AM
Points: 260, Visits: 800
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 "
Post #742481
Posted Friday, June 26, 2009 3:58 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 5, 2014 9:54 PM
Points: 1,687, Visits: 451
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.





- Pradyothana


http://www.msqlserver.com
Post #742499
Posted Friday, June 26, 2009 4:19 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 1, 2014 1:26 PM
Points: 2,242, Visits: 3,645
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





Pradeep Singh
Post #742510
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse