Difference between Create User and Create Login .....♀§♀§♀§

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Difference between Create User and Create...

Difference between Create User and Create Login .....♀§♀§♀§

Rate Topic

Display Mode

Topic Options

Author

Message

forsqlserver

Posted Friday, June 26, 2009 2:42 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 1:33 AM
Points: 1,186, Visits: 1,852

Dear All,

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

Is any one..

Thanks

Post #742464

- Win.

Posted Friday, June 26, 2009 3:16 AM

SSC 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

Pradyothana Shastry

Posted Friday, June 26, 2009 3:58 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, March 25, 2013 5:30 AM
Points: 1,641, Visits: 423

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

ps.

Posted Friday, June 26, 2009 4:19 AM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620

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 »

Permissions