Re: Table ownership

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 10:37:52 +0100

Perhaps the user isn't dbo, but is only a member of db_owner? If so, make sure that the user
specified the owner when the object is created:

CREATE TABLE dbo.Customers 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Anceladux" <Anceladux@discussions.microsoft.com> wrote in message
news:2194B7DD-718D-4FB1-9120-583FE786234D@microsoft.com...
> I always understand that when a user has dbo permission in a database then
> when he/she creates a table then the table will be owned by dbo. For some
> reason on one SQL Server this is not the case. Is there a setting somewhere
> that we can set this?
>
> Thanks
>

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... member of the dbo group and you are automatically given ... Now, given this, why does SQL Server ... Much Thanks Dan. ...
    (microsoft.public.sqlserver.security)
  • Re: Allowing Fully Qualified Queries
    ... If the owner is dbo you can ... When preforming a select I'm supposed to be able to refer> to a database table in the from clause by it's fully qualified name> eg.> ... > How can SQL Server be configured to allow me to specifiy a database table> by it's fully qualified name? ...
    (microsoft.public.sqlserver.setup)
  • Re: Confused about dbo
    ... Jasper Smith (SQL Server MVP) ... > database within a SQL Server instance. ... > There are several ways you could have the username dbo. ... > the true owner of the database. ...
    (microsoft.public.sqlserver.security)
  • Re: DTS Owner
    ... This may help you although I don't know that dbo will ever be able to own them ... Package Ownership Issues ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > owner of the package. ...
    (microsoft.public.sqlserver.dts)
  • Re: DBO Best Practices
    ... lines of always owner qualifying objects... ... someone who are just "a" dbo. ... > doesn't explicitly reference the object's owner (because SQL Server will ... The startup account defines the ...
    (microsoft.public.sqlserver.security)