Re: Different ownership of objects for same user

From: Quentin Ran (ab_at_who.com)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 09:17:49 -0600

Kumar,

when you created the object owned by dbo, you specified it -- create object
dbo.xxx, whereas when you created the other one, you did not specify the
owner -- create object xxx.

Quentin

"kumar ss" <sgnerd@yahoo.com.sg> wrote in message
news:#WRd0b7FEHA.3064@tk2msftngp13.phx.gbl...
> Dear Friends,
> SQL Server 2000.
>
> I have observed an behaviour in my sql server 2000. I have an user 'UA'
> assigned as the 'db_owner' of the database DB_test.
>
> I logged into enterprise manager as user 'UA' and created a table via
> Enterprise Manager. I saw the owner(at enterprise manager)- dbo.
>
> While created another table via query analyser, I saw the owner was
> 'UA'.
>
> Why is this happening? Please shed some light.
>
> Thanks
> Kumar
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: SQL 2000 in a Workgroup - Problem with DBO.xxx
    ... On your web host can you create a table owned by dbo explicitly e.g. ... > Neccessary) and have a Database owner issue. ... Firstly create the DB from another machine using Enterprise Manager ...
    (microsoft.public.sqlserver.security)
  • Re: Developer design Best Practices
    ... The database owner login is a special case and is not specified like a ... You can execute sp_changedbowner to specify the owner or ... > and then I move them, and the owner is dbo. ... > There is NO DBO User in our dev database!! ...
    (microsoft.public.sqlserver.server)
  • Re: **different place for creating a new table**
    ... Both the Enterprise Manager and Query Analyzer tools allow you to specify ... specifies the owner explicitly in its internally generated script but QA ... If you want to create the tables using QA the same way EM does, specify the ...
    (microsoft.public.sqlserver.programming)
  • Re: Table owner is not dbo.
    ... "Kestutis Adomavicius" wrote: ... > default it is not specified, which means that it will be dbo. ... > objects on publisher is not dbo, you should specify the same owner for ...
    (microsoft.public.sqlserver.replication)
  • Re: Table owner is not dbo.
    ... For every publication article you can set destination object owner. ... which means that it will be dbo. ... objects on publisher is not dbo, you should specify the same owner for ...
    (microsoft.public.sqlserver.replication)