Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2003
    Posts
    6

    Unanswered: Sql 2000 Usernames

    Hi,

    Maybe a stupid question, but right now I have no idea how to solve this.

    Whenever a user creates a table in SQL server 2000 the [domain\username] is added to the tablename. Don't know for sure how it works, but other user see it.

    Does the tablename really have to be 'prefix' with the [domain\username].
    Different users need to be able to create the same table from time to time. We have a few queries that use tablenames. But whenever the table's created by a different user, the query doesn't work.

    Is there a way to make query work without the need to change them.

    Thx.

  2. #2
    Join Date
    Oct 2003
    Location
    Sofia
    Posts
    16
    When user creates table he/she should use full name (dbo.table) to be sure that object was created in needed schema. Otherwise object will be created in default user shema.

    Example:
    create XX (a int) - creates krastio.xx, but
    create dbo.XX(a int) - creates dbo.xx

    Resume:
    Lets user write full name when he/she creates common tables
    Last edited by Krastio; 10-29-03 at 09:59.

  3. #3
    Join Date
    Oct 2003
    Posts
    6
    Hi Krastio,

    Thanks for your answer!.

    Maybe I should add a little to my question. Tables are created by importing them from an Access table or somtimes a DBF-table.
    All this is done in Access by using the menu options.
    I don't know how to change the username or write it different.

  4. #4
    Join Date
    Oct 2003
    Location
    Sofia
    Posts
    16
    Hi MeDojo !
    OK, if you can't change shema, lets only "dbo" user transffer common tables.
    Then they will be created in "dbo" shema.

  5. #5
    Join Date
    Oct 2003
    Posts
    6
    Hi krastio,

    I thought of something like that, but how can I make different users work as the 'dbo user'.

    For accessing the sql-tables we use windows authentification and only windows authentification.

    I guess it has something to do with right. I've looked hard but couldn't get it to work.

  6. #6
    Join Date
    Oct 2003
    Location
    Sofia
    Posts
    16
    I'm sorry, I don't know how it happen from Access ((
    But if you use SQL Server EM wizards, it is simple.
    I'm sorry if I can't help you.

  7. #7
    Join Date
    Oct 2003
    Posts
    6
    Thanks for trying to help!

Posting Permissions

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