Re: Cannot delete SQL user (dbowner)

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 09/02/03 

Date: Tue, 2 Sep 2003 14:25:45 -0700

Can you explain a bit more about what you did and what you need? What user
are you trying to delete? Or are you trying to delete a login. Please make
sure you understand the difference between logins and users; there is a lot
of good info in the Books Online.

What message do you get when you say you are not allowed to delete the user?

Every database has a user named dbo and that can never change. What can
change is the login name that the dbo user is mapped to. When you execute
the stored procedure sp_changedbowner, you are changing the mapping between
the user dbo and a login name. 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Carlton Whitmore" <cwhitmore@advocacyinc.org> wrote in message
news:030101c37197$318b29b0$a501280a@phx.gbl...
> I've reassigned the owner to another user, but SQL 2000
> will not allow me to delete the user. How can I get around
> this?
> Carlton.
>

Relevant Pages

  • Re: New DBs DBO does not have an associated login name
    ... But under Enterprise Manager when I drill down to ... the DB and select users the DBO has no associated logon. ... > SQL Server MVP ... >> does not have an associated login name. ...
    (microsoft.public.sqlserver.setup)
  • Re: db_owner role in SQL 2k
    ... Try not to say "If sa is THE dbo", it's like saying "If I am the joe". ... might help to either say "If sa is the database owner" or, ... The login 'sa' could be listed in sysdatabases as the database ... FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: Two DB Owners
    ... full permissions in all databases. ... Note that the user will still be known as the 'dbo' user as long as the ... I need to add the login 'BUILTIN\Administrators' ... > 'DYNGRP' and 'BFGROUP' roles of the Dynamics and DAVCatalog databases. ...
    (microsoft.public.sqlserver.security)
  • Re: How do I set the login name for a user?
    ... You are better to make a dbo roled account (database god?), although that is not my first recommendation for connections. ... name, key name, without login. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: dbcreator and restore?
    ... I also created a backup after the login was set to ... dbo and that is the backup that i successfully restored. ... >SQL Server MVP ...
    (microsoft.public.sqlserver.security)