Re: How to drop login name with the dbo account

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 04/20/04 

Date: Mon, 19 Apr 2004 22:29:43 -0700

Hi Lawrence

DBO is a user name in a database (in fact, EVERY database has a user DBO)
but it is not an account.
It must map to an account in the master database. If you want to get rid of
pfweb_admin, you'll have to map the dbo in whatever database uses it to
another login name. Use sp_changedbowner to change the mapping. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Lawrence" <lawrenceb@ascentium.com> wrote in message
news:5E50A8CF-373E-4246-8997-5AD0B8A31D3C@microsoft.com...
> Hi,
> Currently the dbo account contains login name "pfweb_admin".
> I am trying to get rid of this login name so it dbo account does NOT
require login name.
> "pfweb_admin" is actually a SQL Account with System Admin privileges.  Not
sure how it got associated with dbo account.
>
> Much appreciate any help on this!
> -Lawrence

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)