Home Forums SQL Server 2008 SQL Server 2008 - General SQL DBA knowing user passwords RE: SQL DBA knowing user passwords

  • November 21, 2014 at 9:37 am

    #1760210

    ScottPletcher (11/20/2014)

    Jeff Moden (11/20/2014)

    ZZartin (11/20/2014)

    There's a difference between a service account login used by an application to connect, which a dba should know as the dba is likely the one who will need to configure that login and a user login.

    The DBA doesn't need to know the password of such accounts to maintain those same accounts.

    I'll also say that such accounts should also be Windows Logins and use Windows Authentication rather than SQL SERVER Authentication, just like any other user.

    Not always possible. Some applications are (still) written so as to require a native SQL login to function.

    Unfortunately, that's very true. Still, the DBA doesn't need to know the password to maintain the 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)