Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Login less users in sql ? RE: Login less users in sql ?

  • December 29, 2017 at 7:49 pm

    #1973926

    vsamantha35 - Thursday, December 28, 2017 2:23 PM

    (i mean what are the use cases for login less users)?

    It's great for testing before you "go live" and is an alternate method for assigning permissions where procs can use EXECUTE AS.  You simply create a user in a database WITHOUTLOGIN and go from there.

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