default object owner

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joachim Hofmann - 28 Feb 2005 09:52 GMT

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

Reply to this Message

Sue Hoegemeier - 28 Feb 2005 12:47 GMT

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

>Hello,
>
[quoted text clipped - 6 lines]
>
>Joachim

Reply to this Message