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 ... I try not to think of DBO as the Database Owner, but just as special, ... For anyone to use any database, their login name must have been given access ...
    (microsoft.public.sqlserver.programming)
  • 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)