SQL Objects Owner

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mark (anonymous_at_discussions.microsoft.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 10:48:47 -0700

I have to authorize people in the db_owner group or some
other group (ddladmin etc..) where they should be able to
create tables.

Problem is when they create table using Query Analyzer,
they can mention owner as create table dbo.tablea and the
table is owned by dbo. When they user EM to create the
table, table is owned by their ID and not by dbo. Is it by
design? How do you resolve this issue when people from
db_owner or other group can create DB objects using EM and
still objects owned by dbo.

Thanks in Advance.

Relevant Pages

  • Re: MS Access cant find Recordsource object
    ... the server to more quickly resolve the name. ... I guess I'll get busy prepending dbo. ... I don't want my users running as sysadmins. ... If upgrading isn't an option, ...
    (microsoft.public.sqlserver.server)
  • Re: Can run sp as Administrator but not as User/dbo
    ... ddladmin and db_owner need to qualify the ... table name for it to be owned by dbo. ... If you need the user to be able to execute DDL statements as ... >BTW I changed user from dbo to ddladmin role which seems OK.. ...
    (microsoft.public.sqlserver.security)