Re: Default User

BOL

I am using SQL2000, and con not see a sysadmin role to add myself too. I am
a member of the db_owner Role.

Paul


"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:%23InYO1JjHHA.4064@xxxxxxxxxxxxxxxxxxxxxxx
Paul

BOL says
The dbo is a user that has implied permissions to perform all activities
in the database. Any member of the sysadmin fixed server role who uses a
database is mapped to the special user inside each database called dbo.
Also, any object created by any member of the sysadmin fixed server role
belongs to dbo automatically.

For example, if user Andrew is a member of the sysadmin fixed server role
and creates a table T1, T1 belongs to dbo and is qualified as dbo.T1, not
as Andrew.T1. Conversely, if Andrew is not a member of the sysadmin fixed
server role but is a member only of the db_owner fixed database role and
creates a table T1, T1 belongs to Andrew and is qualified as Andrew.T1.
The table belongs to Andrew because he did not qualify the table as
dbo.T1.

The dbo user cannot be deleted and is always present in every database.

Only objects created by members of the sysadmin fixed server role (or by
the dbo user) belong to dbo. Objects created by any other user who is not
also a member of the sysadmin fixed server role (including members of the
db_owner fixed database role):

a.. Belong to the user creating the object, not dbo.


b.. Are qualified with the name of the user who created the object.
"Paul" <nothanks@xxxxxxxxxxxxxxx> wrote in message
news:7emdnYdtfvLVyqXbnZ2dnUVZ8v-dnZ2d@xxxxxxxxx
What do I need to configure to make the sql tables and stored procedures
I
create, be dbo owned, rather than owned by my id.

I can change the owner in each wizard, or create code, but I usually
forget and have to re do it.

Paul





.

Relevant Pages

  • Re: When creating a new table, owner is DBO I need another user
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Default User
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Permission clarification - dbo vs domainuser.dbo
    ... database is mapped to the special user inside each database called dbo. ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Changing Table Owner and user Owner
    ... Database Owner (dbo) ... any object created by any member of the sysadmin fixed server role ...
    (microsoft.public.sqlserver.security)
  • Re: Permission to Users under DB
    ... public and db_owners database roles. ... The user mapped to dbo ... as being a member of db_owners role although the default ... permissions in the database will be the same. ...
    (microsoft.public.sqlserver.security)