Re: SQL 2000 in a Workgroup - Problem with DBO.xxx

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 12:53:44 +0100

On your web host can you create a table owned by dbo explicitly e.g.

create table dbo.test(a int)

It sounds like you may be in the db_owner or ddl_admin role for your
database on your host. In order to create objects in the dbo schema you will
need to explicitly specify dbo.objectname when creating objects. 

-- 
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
"Daren Hawes" <newsgroups@webdesignmagic.com.au> wrote in message
news:u%23%23gnZZaEHA.3476@tk2msftngp13.phx.gbl...
> Hi,
>
> I have a win xp pro workgroup using simple sharing (No Logins
> Neccessary) and have a Database owner issue.
>
> I have a seperate machine called "Server" with win xp pro on it and SQL
> 2000 SP3a installed.
>
> To create a Database I must go into that machine, create the DB and
> assign that particular DB (Say "Pubs") a user.  I give it a username
> "WDMUsername" and password "WDMPassword".
>
> I then use Enterprise Manager on another machine using the previous
> logins and all is fine... Simple Stuff.
>
> Now I have a web host who uses SQL 2000 as well.  Now if I DTS down to
> my server a DB from them it creates all the tables by the owner ie
> dbo.publishers, dbo.authours.
>
> Now I add a new table and it makes a new table, but with
> wdmusername.newtables.  I can even add a new table called publishers and
> it calls it wdmusername.publishers  I now have 2 Publishers tables!
>
> How can I have a global login using my current workgroup in simple
> sharing mode and do the following.
>
> 1.  Firstly create the DB from another machine using Enterprise Manager
> under the Owner account (IE dbo.table)
>
> 2.  Create tables with the dbo.table format instead of wdmusername.table
> format from any machine using Enterprise Manager.
>
> In a nutshell, by assigning a user to an individual DB and then using
> that username to login is not working.
>
> Can I remove some security and have it create tables under the dbo.
> username from any machine using Enterprise Manager?
>
> PS In the user setup I do the top 2 checkboxes 1 being owner?
>
> Please help!!
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Different ownership of objects for same user
    ... dbo.xxx, whereas when you created the other one, you did not specify the ... owner -- create object xxx. ... > I logged into enterprise manager as user 'UA' and created a table via ... I saw the owner- dbo. ...
    (microsoft.public.sqlserver.programming)
  • Re: ADP: Cant use stored procedure on remote SQL server
    ... Not only I use dbo everywhere but I ... If you don't mention the owner when creating a new stored procedure, view, ... BTW in the database window, all the stored procedures are followed by ... Check also the owner of the SPInc stored procedure. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: rda push when owner is not dbo.
    ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ...
    (microsoft.public.sqlserver.ce)
  • Re: Question about dropping owners permissions...
    ... When a member of the db_owner role creates an object, ... dbo, must the owner must be specified: ... >>> create databases themselves. ... Can anyone help me reach my end goal: Allowing developers to ...
    (microsoft.public.sqlserver.security)
  • 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)