I can't add a user 2

[webmigit]

I'm trying to add a user to my database... A user and a role.

I can't do it for some reason...

I get the error

"Error 15007: The Login 'WhateverUsernameHere' does not exist.".. This is ignorant because I'm trying to create the user via "New User...".

Is it that I don't have enough access to create a user?

As for roles... I'm assuming, from basic experiments in my spare time, that a user's permissions are based on the most liberal role that it is a part of? If one role it is in allows them to do something to a field/row, then that's the one that takes supremacy?

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[jbenson001]

How are you trying to add the user? Are you using a front end app. I am assuming visual studio?

 

[mrdenny]

Sound like you are trying to create a SQL Login but have the radio button for Windows login selected.

A user picks up the permissions from all roles that they are members of. If there is a DENY permission set to a user or roll the DENY permissions overwrites all granted permissions.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[webmigit]

My question was shamefully uneducated and poorly formed.

Thanks MrDenny, you helped clear up some confusion.

Thanks jbenson, You, in effect, pointed out that I'm not asking this in the right place... Most of my SQL questions are about the language itself... Its just habit to come here. I posted a better, revised question in SQL Server DB Administration.

Thanks

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[mrdenny]

Not a problem.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com