Re: Not using SA - Then what?

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 05/31/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Fri, 31 May 2002 13:10:19 -0600

This misconception with db_owners happens a lot - even
though there is the example in books online with the user
who is a member of db_owners.
I've always wondered - was there something in 6.5 where it
worked differently or where multiple users could be mapped
to dbo?

-Sue

On Fri, 31 May 2002 11:48:15 -0700, "Richard Waymire [MS]"
<rwaymi_ms@microsoft.com> wrote:

>Actually this isn't quite correct. The users CAN create objects as
>dbo.objectname but it won't happen by default. Only the one and only dbo
>user will have that happen by default.

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: deny truncate?
    ... environments and the developers are not a member of the db_owner role on the ... > need to be able to create dbo. ... assuming they don't know how to do 'truncate table'. ...
    (microsoft.public.sqlserver.security)