Re: change a user's DB dbo connexion name

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 10/27/05

  • Next message: Dan Guzman: "Re: users" 
    Date: Thu, 27 Oct 2005 07:40:50 -0500

    I'm not sure I understand your question. The database owner's login is the
    login mapping to the database 'dbo' user. You can specify the database
    owner with sp_changedbowner:

        USE MyDatabase
        EXEC sp_changedbowner 'SomeLogin' 

    -- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Scan le Gentil" <scanlegentil@hotmail.com> wrote in message 
news:%23Ewezps2FHA.2364@TK2MSFTNGP12.phx.gbl...
> How to change a user's DB dbo connexion name?
>
>
  • Next message: Dan Guzman: "Re: users"

    Relevant Pages

    • Re: not creating tables as dbo anymore ?
      ... Database Owner (dbo) ... existing user ID in the database specified by database_name. ... with the login of the current connection. ...
      (microsoft.public.sqlserver.security)
    • Re: Change UDF Owner
      ... Does it exist in the master database? ... Users can be put in the dbo role, but dbo will still own objects ... concept of 'schema' as 'owner' rather than just schema as DDL is exploited ... to the appropriate Fixed Server Roles or whatever is applicable. ...
      (microsoft.public.sqlserver.security)
    • Re: Change UDF Owner
      ... system_function_schema -especially in the master database. ... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role, ...
      (microsoft.public.sqlserver.security)
    • Re: Confused about dbo
      ... Jasper Smith (SQL Server MVP) ... > 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)
    • Re: conflicting object names in sql server 2000
      ... On the local database server when it does the select * from ... > michael.xxx Note that michael is the owner of the database. ... it will see if there is one owned by dbo. ...
      (microsoft.public.sqlserver.server)