Default schema

  • Comments posted to this topic are about the item Default schema

  • Hi,

    the question and it's given answer is nonsence. You talk in your "solution" about the sysadmin role!

    But in your script you add the user to the db_owner role.

    If the user is member of the db_owner role the default schema will be used!

    Microsoft Certified Master: SQL Server 2008
    MVP - Data Platform (2013 - ...)
    my blog: http://www.sqlmaster.de (german only!)

  • +1 to the above.

    How are you able to infer a relationship that is neither stated nor implied?

  • Nowhere in the question it is mention that login 'king_login' is part of sysadmin fixed server role?

    Neither in the script login 'king_login' had been added to the fixed server role 'sysadmin'?

    It is impossible to read the mind of the people what is the exemption!

    Anoop, it would be good if you state all your assumptions so that people can answer correctly and retain interest in QotD.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Wowwww !!!! ... MAY Be ... :hehe:

  • WTH?

    The script doesn't mention sysadmin but database owner.

    The created user doesn't have sysadmin permissions, so the table will be created using the default schema.

    Points back please!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • +1 to the above

    points back please..

  • Note a quite low percentage of correct answers so far.

    Igor Micev,
    My blog: www.igormicev.com

  • Louis Hillebrand (3/31/2014)


    +1 to the above

    points back please..

    +1...

    Crystal balls are not working Monday morning...

  • Koen Verbeeck (3/31/2014)


    WTH?

    The script doesn't mention sysadmin but database owner.

    The created user doesn't have sysadmin permissions, so the table will be created using the default schema.

    Points back please!

    What Koen said !

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan I would never join a club that would allow me as a member - Groucho Marx

  • Who came up with this rot? Duped!!

  • I also answered that the table would be created in the King-schema as there was no mention about the user being in the sysadmin role.

    I have to be honest that i do not agree with the 'correct' answer...

  • Along with most others, I fell into this trap and answered "king_schema". However I do NOT think it's a bad question.

    The script doesn't mention anything about the creation of king_login, so it is implied that this login already exists. In that case, we cannot assume that it either is or isn't already a member of any server roles, including sysadmin.

    The fact that the user was created and added to the db_owner database role is just a red herring.

    Thanks for the question Anoo.

    -----
    JL

  • James Lean (3/31/2014)The script doesn't mention anything about the creation of king_login, so it is implied that this login already exists. In that case, we cannot assume that it either is or isn't already a member of any server roles, including sysadmin.

    The fact that the user was created and added to the db_owner database role is just a red herring.

    Thanks for the question Anoo.

    Hmm - in a real scenario I have the chance to check an account. If I don't get the correct information my "reaction" suffers because of missing IMPORTANT information. That's not the way a dba should do his work and that's not the way the "correct" answer for this question should be!

    This question is by the given reason for right or wrong absolute nonsence because the most important information (the login is sysadmin) is missing.

    If I would ask you whether a INSERT INTO ... WITH (TABLOCK) is bulk logged or not you need to know what recovery model is your database running. If you don't have this information you have a chance of 33% for the correct doing 😛

    Microsoft Certified Master: SQL Server 2008
    MVP - Data Platform (2013 - ...)
    my blog: http://www.sqlmaster.de (german only!)

  • This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 61 total)

You must be logged in to reply to this topic. Login to reply