Home Forums SQL Server 2012 SQL 2012 - General default schema of windows group user RE: default schema of windows group user

  • October 2, 2014 at 8:23 am

    #1749694

    sqlfriends (10/1/2014)

    I am using SQL server 2012.

    An user tried to export tables from GIS application to the SQL database.

    After export, and login to the SQL server, we see all the tables has his name as the schema but not dbo.

    He was added as a login and user as in a windows group. Meaning he is a member of the windows group.

    I assume when export, the default schema should be dbo. but apparently not.

    I went to the setting and explicitly make the default schema for the windows group user to dbo. But he tried again, it still use his username as schema prefix to the tables.

    just wondering why is this?

    Thanks,

    It sounnds like the user has a separate login other than just being a member of the group. You either need to drop the login or fix the default schema of his separate login.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)