Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    3

    Unanswered: db_owner role and table owner issues

    Hi,

    I have given a user db_owner role in a database. When he creates a table using Enterprise manager the table owner is dbo. When he creates a table using Query Analyzer the table owner is the user. eg

    Enterprise Manager = dbo.Table1

    Query Analyer = username.Table1


    This causes a problem when the user is writing web applications. Is this an error in the way i have set up permissions ? How can i make them behave the same way?

    Thanks for your help.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    First, don't create tables in EM

    Second, it's how they are connecting...

    Third, depending on how you want the application to work, qualify the owner...

    Fourth, get control...

    have them supply you with the DDL, and you create the tables for them...

    My guess is that EM is connected with sa, and QA is connecting with their id...

    just a guess...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Posts
    3
    Thanks for your quick response. I should have included the following information.

    I work in a University computing department where students must learn to create tables etc. I could not create their tables for them as it is part of their assessment (and there are 1700 students!)

    Students can only log on to the server using windows authentication so will log on using the same windows account to both EM and QA.

    Students are taught to use both EM and QA which is why they are finding problems.

    Thanks again for all help.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Gotta test it...which way do you want the tables qualified for their apps...

    dbo?

    I'll look into it...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Feb 2004
    Posts
    3
    yes dbo thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •