Re: owner name listed for OWNER column

From: Darius Kvitnickas (anonymous@devdex.com)
Date: 10/11/02 

From:     Darius Kvitnickas <anonymous@devdex.com>
Date: Fri, 11 Oct 2002 00:29:39 -0700

I've only tested your problem in sql server 2000, so I don't know if
there's any difference, but most probably your user is the member of
System Administrators (sysadmin) server role. If so any object created
in DB is owned by dbo.
I've created table when the user has only serveradmin, but not sysadmin
server role, and the owner of the table was the user's name, not dbo.

read more 'bout Database Owner (dbo) in BOL

Darius
Sql\Asp\VB developer

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Fatal error 682 and SqlDependency
    ... for the 'sa' account; now all works as it should. ... From my experience this error typically happens when 'dbo' maps to a login ... However, this error is unrelated to the size of the query notification, is ... When this error happens in the server messages for one query notification ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: User names
    ... I don't have a pre-sp3 server to try this on, but in sp3, if you are a user ... byjust specifically giving the owner name in QA. ... > dbo was the owner. ...
    (microsoft.public.sqlserver.server)
  • 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)
  • Re: Security Problem with AD Group in SQL Server Security Logins area
    ... role they were mapped to the dbo user in each database. ... Jasper Smith (SQL Server MVP) ... >> system role of "System Administrators." ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 7.0 and MS Access permission issue
    ... The dbo user in a database is mapped to the sysadmin fixed server ... If your DSN uses integrated security, then the database user will be ...
    (microsoft.public.sqlserver.security)
Loading