Home Forums SQL Server 2014 Administration - SQL Server 2014 Consequences of making "dbo", directly, the owner of db_datareader schema RE: Consequences of making "dbo", directly, the owner of db_datareader schema

  • February 26, 2018 at 11:22 am

    #1981156

    Your original posts states that you want to delete the db_datareader role after assigning it's schema to DBA.  Since it's a database fixed role, I'm not sure that you could delete it (I've not tried and probably won't because there's no reason to do such a thing) but, if you could delete it, I'm thinking that some seriously bad stuff is going to happen with your security because the system will check for the role while do other things (like normal login management, etc) and, when it can't find it, there will be forms of flying Kimchi that will make you cry out loud.

    To summarize, don't even think of doing this

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