Re: not creating tables as dbo anymore ?

From: Francis (FMignault@newtrade.com)
Date: 03/05/03 

From: "Francis" <FMignault@newtrade.com>
Date: Wed, 5 Mar 2003 07:06:47 -0800

I would like it to create the tables as dbo without
specifying it.

I know it is possible because it was doing it before but
something changed and I don't know what.

I saw that there is a dbo user associated to the database.
Can I associate my user to it ?

Francis.

>-----Original Message-----
>Hello, Francis!
>
>Have the user create the table using CREATE TABLE
dbo.TableName(...........
>
>
>
>--
>
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>: I have userA that has access to one database as
>: db_owner.
>
>: How come, when I create a table it is not owned by dbo ?
>: It creates the tables as userA.table ...
>
>: I don't understand. How can I setup the user so that it
>: will create objects as dbo ?
>
> --- Microsoft CDO for Windows 2000
>
>
>.
>

Relevant Pages

  • 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
    ... I do the select user_nameand get dbo ... Do you mean EM lists VDW as the owner of the database? ... I presume then that you are logged in as tfs. ... So my guess is that the login tfs is in the sysadmin role on the server, ...
    (microsoft.public.sqlserver.programming)
  • Re: Groups for dbo
    ... Thanks for the instructions on changing the database owner...I suspect ... While dbo is SUPPOSED to be a special user that's not used for routine ... It's probably safer to change the database owner in any event, ... >> I'm still fairly new to SQL Server, and I'm trying to figure something ...
    (microsoft.public.sqlserver.security)
  • Re: Change UDF Owner
    ... system_function_schema -especially in the master database. ... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role, ...
    (microsoft.public.sqlserver.security)
  • 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)