Re: dbo permissions

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/22/05 

Date: Wed, 21 Sep 2005 19:52:04 -0600

dbo is a special user account that exists in every database
but there isn't a login named dbo.
The login that owns the database is has the name DBO in that
database.
It's easier to not think of dbo as an user account as it
doesn't have a login and doesn't work like a typical user in
a database.

One other note on the login and hope this doesn't confuse
things but dbo isn't a login based on the special account
that exists in all databases. By default and generally on
most SQL Servers there is no login dbo. In theory you can
create a SQL login named dbo but it's not the same thing.
isn't a good practice and confuses things quite a bit. I saw
one place do that before...not a good thing to create
something like that.

-Sue

On Wed, 21 Sep 2005 13:39:08 -0400, "robertcp"
<rplance@bmhsc.org> wrote:

>Is it possible for the dbo account to have a login to an SQL server?
>If so how can that be discontinued?
>

Relevant Pages

  • Re: Confused about dbo
    ... neither the explicit database owner or aliased to the dbo user. ... member of the db_owner role does not mean you are aliased to the dbo user. ... When you connect to SQL Server you do so using a login. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... Windows login name. ... login that is the owner of a database and members of the sysadmin role. ... >> the username dbo" ... >> FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... The owner of a database is a login, which is listed in the sysdatabases ... I try not to think of DBO as the Database Owner, but just as special, ... For anyone to use any database, their login name must have been given access ...
    (microsoft.public.sqlserver.programming)
  • Re: db_owner role in SQL 2k
    ... > The owner of a database is a login, which is listed in the sysdatabases ... > table in the master database as the owner of the database. ... and their user name will ALWAYS be DBO. ... > automatically members of the public role. ...
    (microsoft.public.sqlserver.programming)