login and users

Question

Post reply

login and users

shanila_minnu

Hall of Fame

Points: 3465
More actions
May 20, 2009 at 6:34 am

#131203

i want to know the difference between login and users...

if a request came, "provide access to the database ABC of the server XYZ" what should i do...will i have to create a new user or a new login and granting access to the particular database....wat will happen if i gave database name as master while giving access to a login

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

BLADE-1043594 SSCrazy Points: 2576 More actions · Answer 1

BLADE-1043594

SSCrazy

Points: 2576

May 20, 2009 at 6:52 am

#997550

A SQL Server login allows a user to connect to a server, whereas a

database user is associated with a login to allow specific permissions

on that database. A login is the base concept, and a dbuser inherits

from that.

[font="Comic Sans MS"]+++BLADE+++[/font]:cool:

BLADE-1043594 SSCrazy Points: 2576 More actions · Answer 2

if a request came, "provide access to the database ABC of the server XYZ" what should i do...will i have to create a new user or a new login and granting access to the particular database....wat will happen if i gave database name as master while giving access to a login

It means you have to provide a new login to access the database ABC of server XYZ.You have to create new login and map the to that particular user

[font="Comic Sans MS"]+++BLADE+++[/font]:cool:

Schadenfreude-Mei SSChampion Points: 14083 More actions · Answer 3

shanila_minnu (5/20/2009)

i want to know the difference between login and users...

if a request came, "provide access to the database ABC of the server XYZ" what should i do...will i have to create a new user or a new login and granting access to the particular database....wat will happen if i gave database name as master while giving access to a login

Ok so firstly welcome and secondly it is important that you understand the difference.

Login:

A login is a record in the master database which gives access to the sql server (that’s not to say that any specific database access is implied, though this can be done via 'server roles'). There are two types of logins available in sql 2005. One is the sql login which is local to the server with its own password and sid stored in master. The second is Windows/NT accounts; these can be either NT accounts (local or domain) or groups. These accounts are essentially lookups to the DC (or account control service) to verify the authenticity of the credentials (also known as single sign-on).

User:

A useer is a 'Database User', this is essentially a shortcut or lookup store in the ABC database which records the fact that a 'Login' has access to do 'stuff'. The database ABC stores the logins SID and name (these must match up; ie, there can be complications when moving between servers (sql account) and domains (NT account).

To answer your questions; if a request comes to give a 'person' access who doesnt already have a 'Login', you must create a login on the sql server (sql or NT). Master as default database is the default (but without additional rights the cant do anything). You then create a Database User (can be done at login creation 'User Mappings') which gives the specific database access.

Hope that’s clear. If in doubt do a BOL search or let me know.

Adam Zacks-------------------------------------------Be Nice, Or Leave