idol steps to take

  • rk1980factor

    SSCommitted

    Points: 1681

    If a Junior Developer whom you have not met before, submits a request for DBO permissions on a production system. What are the idol steps should be completed?

  • John Mitchell-245523

    SSC Guru

    Points: 148218

    I'd start by asking why he needs it.  In an ideal world, developers wouldn't have any access to live systems, and certainly not elevated permissions like he's asking for.

    John

  • Thom A

    SSC Guru

    Points: 98011

    John Mitchell-245523 wrote:

    I'd start by asking why he needs it.  In an ideal world, developers wouldn't have any access to live systems, and certainly not elevated permissions like he's asking for. John

    +1.

    This very much falls in line with the opinion/response I gave you in your other question accidentally dropping production. Developers are very unlikely to need to be able to do anything and everything in a production database; especially a Junior Developer. If they really need to be doing something above their permissions, they should be escalating the request upwards though the correct channels (that your business will already have documented) and getting someone who can perform the action to do so.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

  • Grant Fritchey

    SSC Guru

    Points: 395211

    There was a time when my primary concern on something like this would be simple worries about whether or not the junior (or senior, or mid-range) developer should be on production in the first place because of dropped tables, etc.. However, the more I know about privacy and compliance from HIPAA, PCI, GDPR, CPPA, FERPA, WPA, and SOX, the more I'm very comfortable in denying that access based purely on business needs. The whole technical aspect of the problem, which has always been a concern of mine, is completely subsumed by the compliance issues.

    NO. You don't get access to production and the business is going to back me up on it (probably, at least after they get their first GDPR fine).

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Jeff Moden

    SSC Guru

    Points: 993628

    Lordy... all these interview questions you're asking.  And the word should be "ideal" and not "idol". 😉

     

    The bottom line should be that NO ONE gets any privs to prod without going through proper channels.  Since the Junior didn't go through the proper channels, you tell me what your answer should be.  And, yeah... report the Junior's request to the proper chain of command.

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • Thom A

    SSC Guru

    Points: 98011

    Jeff Moden wrote:

    Lordy... all these interview questions you're asking.  And the word should be "ideal" and not "idol". 😉

    Perhaps the OP really does want to know the steps their idol would take in the event they're described. if so, the real question is, who is there idol? Let's just hope it isn't someone like one of the Kardashian's or a well known celebrity Chef, and instead a renowned (and respected) member of the SQL Server community. ??

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.

Viewing 6 posts - 1 through 6 (of 6 total)

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