Re: **different place for creating a new table**

From: Uri Dimant (urid_at_iscar.co.il)
Date: 06/06/04 

Date: Sun, 6 Jun 2004 09:38:55 +0200

RM
BOL says:
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.
"RM" <m_r1824@yahoo.co.uk> wrote in message
news:opr85p4f08hqligo@msnews.microsoft.com...
> hi
>
> I want to create a new table "T1" in my database called "db1" in SQL
> server 2000 with a db_owner user,("L1","U1")
> I did it successfully in 2 ways ,but there was a difference in result:
> 1) I created in enterprise manager
> as I logined with L1 ,and when I saw T1 in
> query analyzer table list in db1 it was in shape
> of "dbo.t1".
> 2) I created it programatically as I logined
> with L1 in query analyzer and the shape of
> result appearred in table list of db1 in left
> window of query analyzer was "L1.t1".
> why??????
> what's the difference?
> why when I logined in enterprise manager as
> L1,it saved my table as dbo?
>
> any help would be greatly appreciated.

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: TRUNCATE TABLE permissions
    ... permissions of another user who did have those rights. ... > Is there any possibility to give the TRUNCATE TABLE permission and avoid> that the user that will execute this statement be table owner, members of the> sysadmin fixed server role, db_owner or member of the db_ddladmin fixed> database roles? ...
    (microsoft.public.sqlserver.server)
  • Owners other than DBO
    ... Any user belonging to the sysadmin fixed server role and ... db_owner fixed database role always manipulates database ... >How do I get ACTDMS to work in addition to DBO? ...
    (microsoft.public.sqlserver.security)
  • Re: sp_adduser
    ... Only the dbo and members of the sysadmin fixed server role can execute ...
    (microsoft.public.sqlserver.security)
Loading