Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Unhappy Unanswered: Create tables under different users.

    I know this may sound stupid but I really can't figure out how to do it. I just keep going around in cricles.

    I need to create six table under three different users. so I would have users1 owning tableA and tableB. Then I would have users2 owning another copy of tableA and tableB. same for users3.

    But I just can't find a way of doing it, I am using enterprise manager. Please help, Ed

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It's painful using Enterprise Mangler. Can you use Query Analyzer?

    -PatP

  3. #3
    Join Date
    Jul 2003
    Posts
    100
    Yep, I can use the Query Analyses can you tell me how? Ed

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    CREATE TABLE user1.TableA(Col1 int, ect...
    CREATE TABLE user1.TableB(Col1 int, ect...
    CREATE TABLE user2.TableA(Col1 int, ect...
    CREATE TABLE user2.TableB(Col1 int, ect...
    CREATE TABLE user3.TableA(Col1 int, ect...
    CREATE TABLE user3.TableB(Col1 int, ect...
    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
    Jul 2003
    Posts
    100
    Excellent thanks!

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Of course, the unasked question is WHETHER you should do this...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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