Changing Login name for dbo

From: Rick Price (rprice453@yahoo.com)
Date: 10/29/02


From: "Rick Price" <rprice453@yahoo.com>
Date: Tue, 29 Oct 2002 05:11:44 -0800


Never mind - Solved the problem with sp_changedbowner
>-----Original Message-----
>I have a database on a remote machine that a user
created
>and assigned his login to dbo. I can create a new user,
>drop old ones but have never had to modify the login
>name. I can't just drop it and recreate it because dbo
>owns objects in the db.
>
>Any help appreciated.
>.
>



Relevant Pages

  • 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)
  • Re: Confused about dbo
    ... Make sure you understand the difference between login names and user names. ... database within a SQL Server instance. ... There are several ways you could have the username dbo. ... the true owner of the database. ...
    (microsoft.public.sqlserver.security)