Re: Confused about dbo

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/27/05 

Date: Sat, 27 Aug 2005 00:05:44 +0100

What does running the following in your database return

select current_user

It sounds like you are the database owner (your login has been mapped to the
dbo user in the database) since if you were simply a member of the db_owner
role you would indeed have to prefic objects with dbo when creating them. 

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"msnews.microsoft.com" <Rene> wrote in message 
news:eDSuZ9oqFHA.3540@TK2MSFTNGP14.phx.gbl...
>I recently signed up with a web hosting company. The hosting package 
>included a Microsoft SQL server database with it.
>
> Anyway here is my question. I know for sure that I am not the owner of the 
> database (dbo) because hosting companies don't allow their customer to 
> create their own databases, so why is it that when I create a table the 
> owner of the table shows up as dbo? I would think that the owner should be 
> my user name right?
>
> Why is this happening?
>
> Thanks for your help.
>
>

Relevant Pages

  • Re: not creating tables as dbo anymore ?
    ... Database Owner (dbo) ... existing user ID in the database specified by database_name. ... with the login of the current connection. ...
    (microsoft.public.sqlserver.security)
  • Re: Change UDF Owner
    ... Does it exist in the master database? ... Users can be put in the dbo role, but dbo will still own objects ... concept of 'schema' as 'owner' rather than just schema as DDL is exploited ... to the appropriate Fixed Server Roles or whatever is applicable. ...
    (microsoft.public.sqlserver.security)
  • Re: Change UDF Owner
    ... system_function_schema -especially in the master database. ... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role, ...
    (microsoft.public.sqlserver.security)
  • 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: 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)