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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: Please! Doesnt anyone know a better way to do this?
    ... account, they need to automatically be directed to the page to enter data ... session variable on the Account page. ... I assume here that you're checking a database when the user attempts to ... When a new user attempts to login or clicks to register, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Confused about dbo
    ... neither the explicit database owner or aliased to the dbo user. ... member of the db_owner role does not mean you are aliased to the dbo user. ... When you connect to SQL Server you do so using a login. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... Windows login name. ... login that is the owner of a database and members of the sysadmin role. ... >> the username dbo" ... >> FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... > The owner of a database is a login, which is listed in the sysdatabases ... > table in the master database as the owner of the database. ... and their user name will ALWAYS be DBO. ... > automatically members of the public role. ...
    (microsoft.public.sqlserver.programming)