Re: How do I set the login name for a user?

That is not a user, in the traditional sense.

It may show up in the tool, but it is not a user you can use. Consider it a database role or a superuser.

The sa account is "god" on the server. You can use it in connection strings, et al, but I would highly discourage it. You are better to make a dbo roled account (database god?), although that is not my first recommendation for connections. It is best to only give the rights necessary to the account. read and write priveleges are generally as far as I would go with an account to read data from an application.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#

or just read it:
http://feeds.feedburner.com/GregoryBeamer

********************************************
| Think outside the box! |
********************************************
"David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message news:mthve499b159uread0p05k4n4sjf4ahrka@xxxxxxxxxx
On Thu, 9 Oct 2008 22:31:57 -0500, "Cowboy \(Gregory A. Beamer\)"
<NoSpamMgbworld@xxxxxxxxxxxxxxxxxx> wrote:

dbo is a role, not a user.

I am not sure what properties you are talking about? What tool are you
seeing this in? And, how did you get to this "page" in the tool?

Hi;

Here's what I am seeing. In SQL Server Management Studio I go to
Databases/KailuaTest/Security/Users and under that I have the user
dbo.

When I bring up the properties for dbo it has a Username of dbo and
under that are 4 greyed out radio buttons: login name, certificate
name, key name, without login. login name is grayed out.

The problem is to the right of login name the text box that lists the
username is blank And as it's grayed out, there is no way to set a
login name.

So I created a seconf user dbo2, set it to db_owner, and was then
goign to delete dbo - but it won't let me.

So how can I fix this?

thanks - dave

david@at-at-at@windward.dot.dot.net
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

.

Loading