Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

user, login and group

Status
Not open for further replies.
kindus

kindus

IS-IT--Management
Jul 25, 2001
77
US
I am new to SQL Server, I need a quick understanding on the following :

A login_id is attached to user_id and user_id is associated with a group. my queries would be
1) is login_id and user_id mapped one-to-one?
2) I could create a user without attaching to login-id. How do I connect to database as that user?
3) Anything which explains user, login and role better would be great !!

Anyone experienced in SQLServer may please explain these for me.

thanks
 
Status
Not open for further replies.

Similar threads

Cpreston
  • Locked
  • Question
Group results into one row 3
2
Replies
37
Views
3K
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
SELECT TOP 1 of Each of a Group
Replies
5
Views
692
grnzbra
grnzbra
peac3
  • Locked
  • Question
Gaps and islands
Replies
8
Views
810
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
808
Andrzejek
Andrzejek
Marclem
  • Locked
  • Question
Get Opinio Last Login Data
Replies
5
Views
564
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top