Re: Confused about dbo

Rene
Date: 08/27/05 

Date: Fri, 26 Aug 2005 18:21:32 -0500

Hey Japer:

Well, I am away from the computer that has access to the database so I can't
run the "select current_user" function right now, however, isn't me being
the dbo a bad thing from the point of view of the hosting company?

Wouldn't I be able to do things such as increase my database space or screw
some other things up by me being a dbo? Especially since my database is on a
shared SQL server?

Thanks

"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:%23VFQqKpqFHA.3540@TK2MSFTNGP14.phx.gbl...
> 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: 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: Cannot view DB properties
    ... # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server ... owner was NULL after the UPgraded finished successfully. ... The proposed new database owner is already a user or aliased in the ... Sorry, I don't understand, what do you mean by "In-Place Upgrade"? ...
    (microsoft.public.sqlserver.security)
  • Re: HELP - I goofed when creating a database
    ... details) go to which date record - is not stored in your database; ... some reading on the merits of SQL Server vs Access. ... you select the owner or enter a new one, enter the date ordered, then ... ownerID - PK ...
    (comp.databases.ms-access)
  • 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)