Post reply

If user is mapped to master, can they access all dbs?

  • March 5, 2015 at 12:48 pm

    #295021

    If a user is mapped to "master", (in login properties, user mapping) are they able to access all dbs, even though "master" is the only one with the check mark?

  • March 5, 2015 at 1:05 pm

    #1782025

    No.

  • March 5, 2015 at 1:20 pm

    #1782029

    To expand on what Nevyn said, they will only have access to Master.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • March 5, 2015 at 3:55 pm

    #1782055

    And to add to what Alan said, I wouldn't do such a thing on any given day. 😉

    --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)

Viewing 4 posts - 1 through 3 (of 3 total)

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