Re: Confused about dbo

From: Rene (nospam_at_nospam.com)
Date: 08/27/05

  • Next message: Rene: "Re: Confused about dbo" 
    Date: Fri, 26 Aug 2005 21:29:05 -0500

    Well, it turns out that the owner of the database is a user called
    "dbcreator" which looks like is a predefine server role.

    I am still kind of lost about this dbo:

    1) You said "A third way to have the username dbo is that your login name
    might be
    aliased to the username dbo". Where can I see this alias mapping? Is there
    an entry on some table that I can query with this iformation?

    2) Is dbo an actual user? Can you logon to the database using dbo as your
    logging name?

    3) I was able to go to the database properties and change the "Restrinct
    file grow" amount. What does this means? Does it mean that I am half dbo and
    half restricted user?

    Thanks

    "Kalen Delaney" <replies@public_newsgroups.com> wrote in message
    news:OhE0HsqqFHA.4012@TK2MSFTNGP12.phx.gbl...
    > Jasper
    >
    > Make sure you understand the difference between login names and user
    > names. Please read about them in the Books Online.
    >
    > A login name is how you get access to SQL Server. Your login name is then
    > mapped to a user name in a particular database, to give you access to that
    > database within a SQL Server instance.
    >
    > There are several ways you could have the username dbo. One is if you are
    > the true owner of the database. Another way is if you are in the sysadmin
    > server role. From your description, it sounds like this is not the case,
    > as that would give you WAY too much power.
    >
    > A third way to have the username dbo is that your login name might be
    > aliased to the username dbo, which means you are not the real owner, but
    > within the database, you have all the privileges of the owner. A user
    > aliased to the dbo cannot do things outside the db, like increasing its
    > size.
    >
    > In addition to current_user, you can also do the following:
    >
    > sp_helpdb <name of db>
    >
    > This will tell you who is the true owner of the db. Also
    >
    > SELECT suser_sname()
    >
    > will tell you what your login name is.
    >
    > HTH
    > Kalen Delaney
    > www.SolidQualityLearning.com
    >
    > <Rene> wrote in message news:uFPwhTpqFHA.3604@tk2msftngp13.phx.gbl...
    >> 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.
    >>>>
    >>>>
    >>>
    >>>
    >>
    >>
    >
    >

  • Next message: Rene: "Re: Confused about dbo"

    Relevant Pages

    • Re: How to prevent DELETEs in a table
      ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ... SQL Server just skips any permission validation for sysadmins. ...
      (microsoft.public.sqlserver.server)
    • Re: conflicting object names in sql server 2000
      ... The owner of the object will depend on the user ... On the local database server when it does the select * from ... she must specify the owner: ...
      (microsoft.public.sqlserver.server)
    • 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: 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)