Re: default object owner

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 02/28/05 

Date: Mon, 28 Feb 2005 05:47:47 -0700

A user needs to be a member of db_owner or db_ddladmin roles
(or sysadmin) to create a table owned by dbo. Members of
db_owner and db_ddladmin need to qualify the owner as
dbo.object when they create the objects to be owned by dbo.
As close as you can get to your request is to just set a
coding standard with db_owners to qualify all objects when
creating them.

-Sue

On Mon, 28 Feb 2005 10:52:56 +0100, Joachim Hofmann
<speicher@freenet.de> wrote:

>Hello,
>
>It seems not sufficient to be a member of group dbo to make dbo the default owner
>of newly created objects.
>Being member of 'System Administrators' accomplishes this.
>But is there a moderate possibility to make this default behavior work?
>
>
>Thank You
>
>Joachim

Relevant Pages

  • Re: When creating a new table, owner is DBO I need another user
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Default User
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Default User
    ... a member of the db_owner Role. ... The dbo is a user that has implied permissions to perform all activities ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Changing Table Owner and user Owner
    ... Database Owner (dbo) ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • RE: View Designer Role and Security
    ... Have you tried making the user a member of the db_owner role and when he ... This will make the dbo the owner of the view so you should not have to give ... This posting is provided "as is" with no warranties and confers no rights. ...
    (microsoft.public.sqlserver.security)