PostgreSQLのRow Level SecurityをPHPのORMで扱う Eloquent vs Doctrine #phpcon #track2

https://fortee.jp/phpcon-2025/proposal/80764564-29d0-4cf1-a126-7662c2ad6cac

Transcript

1. BU
   1)1
   $POGFSFODF
   
   PO
   UI
   +VOF
   CZ
   !XFC 1PTUHSF42-ͷ3PX
   -FWFM
   4FDVSJUZΛ1)1ͷ03.Ͱѻ͏ &MPRVFOU
   WT
   %PDUSJOF
2. )JSPNJ
   )JTIJEB !XFC w 1)1FS
   GPS
   
   ZFBST
   w MJWF
   JO
   /BHPZB
   w 'VMMDZDMF
   FOHJOFFS
   BU
   
   -JOLBHFJOD
   w .PUIFS
   PG
   UXP
   w $PPSHBOJ[FS
   PG
   1)1
   $POGFSFODF
   /BHPZB
   
   w MPWF
   4ZNGPOZ
   
   %PDUSJOF
3. "HFOEB w 8IBUT
   3-4
   w )PX
   UP
   VTF
   3-4
   JO
   1)1 1PTUHSF42-
   w )PX
   UP
   VTF
   3-4
   XJUI
   &MPRVFOU 1PTUHSF42-
   w )PX
   UP
   VTF
   3-4
   XJUI
   %PDUSJOF 1PTUHSF42-
   w 5FBNT
   EFDJTJPO
4. 8IBUT
   3PX
   -FWFM
   4FDVSJUZ w %BUB
   BDDFTT
   DPOUSPM SFBE
   
   XSJUF
   w #BTFE
   PO
   VTFST
   QFSNJTTJPOT
   w 6TF
   POF
   EBUBCBTF
   BT
   JG
   TFQBSBUF
   EBUBCBTFT
   XPSL
   XJUI
   NVMUJ
   UFOBOUT
5. 8IBUT
   3PX
   -FWFM
   4FDVSJUZ 3-4
   JO
   "DUJPO
   4&-&$5 
   BT
   B
   VTFS
   XJUI
   UFOBOU@JE
   QFSNJTTJPO
6. 8IBUT
   3PX
   -FWFM
   4FDVSJUZ 3-4
   JO
   "DUJPO
   */4&35 
   BT
   B
   VTFS
   XJUI
   UFOBOU@JE
   QFSNJTTJPO
   JU
   XPSLT 
   BT
   B
   VTFS
   XJUI
   UFOBOU@JE
   QFSNJTTJPO
   JU
   EPFTOU
   XPSL
   🙅
7. 8IBUT
   3PX
   -FWFM
   4FDVSJUZ 3-4
   JO
   "DUJPO
   61%"5&
   
   %&-&5& 
   BT
   B
   VTFS
   XJUI
   UFOBOU@JE
   QFSNJTTJPO
   JU
   XPSLT 
   BT
   B
   VTFS
   XJUI
   UFOBOU@JE
   QFSNJTTJPO
   JU
   EPFTOU
   XPSL
   🙅
8. 8IBUT
   3PX
   -FWFM
   4FDVSJUZ w 1SPT
   w "WPJE
   DSPTTUFOBOU
   EBUB
   MFBLBHF
   w 7JSUVBM
   NVMUJQMF
   EBUBCBTF
   w ,FFQ
   EFQMPZ
   FBTZ
   w ,FFQ
   MPXFS
   DPTU
   w 1BSUJBM
   VTBHF
   w $POT
   w $PNQMFYJUZ
   w 3JTL
   PG
   EFHSBEFE
   RVFSZ
   QFSGPSNBODF IUUQTTPVEBJIBUFOBCMPHDPNFOUSZ IUUQTTQFBLFSEFDLDPNTPVEBJVUJMJ[JOHSTMJONVMUJUFOBODZ ৄ͘͠͸
9. w $SFBUF
   TQFDJ fi D
   SPMF
   
   MPHJO
   SPMF
   GPS
   B
   UFOBOU
   
   VTFS
   w $SFBUF
   QPMJDZ
   GPS
   UBCMFT
   UP
   BMMPX
   
   QFSNJTTJPO
   w 1PTUHSF42-
   EPFT
   UIF
   XPSL
   
   w BMMPX
   EBUB
   BDDFTT
   POMZ
   UP
   VTFS
   XJUI
   QFSNJTTJPO )PX
   UP
   TFU
   VQ
   3-4
   GPS
   B
   UFOBOU IUUQTTPVEBJIBUFOBCMPHDPNFOUSZ IUUQTTQFBLFSEFDLDPNTPVEBJVUJMJ[JOHSTMJONVMUJUFOBODZ ৄ͘͠͸
10. )PX
    UP
    VTF
    3-4
    JO
    1)1 w 6TF
    TQFDJ fi D
    DPOOFDUJPO
    GPS
    UIF
    UFOBOU
    w &YFDVUF
    TFMFDU
    JOTFSU
    VQEBUF
    EFMFUF
    POMZ
    WJB
    UFOBOU
    TQFDJ D
    DPOOFDUJPO
11. )PX
    UP
    VTF
    3-4
    JO
    1)1
12. w &MPRVFOU
    BMMPXT
    NVMUJQMF
    DPOOFDUJPOT
    w #VU
    POMZ
    GPS
    TUBUJD
    NVMUJQMF
    DPOOFDUJPOT
    MJLF
    VTFST
    UBCMF
    GPS
    NBJO
    DPOOFDUJPO
    CPPLT
    UBCMF
    GPS
    BOPUIFS
    DPOOFDUJPO
    w 8F
    OFFE
    EZOBNJD
    NVMUJQMF
    DPOOFDUJPO
    UP
    VTF
    3-4
    w UIF
    NPSF
    UFOBOU
    UIF
    NPSF
    EBUBCBTF
    DPOOFDUJPOT )PX
    UP
    VTF
    3-4
    XJUI
    &MPRVFOU
13. )PX
    UP
    VTF
    3-4
    XJUI
    &MPRVFOU
14. )PX
    UP
    VTF
    3-4
    XJUI
    &MPRVFOU
15. )PX
    UP
    VTF
    3-4
    XJUI
    &MPRVFOU w 1SPT
    w "GUFS
    TXJUDIJOH
    DPOOFDUJPOT
    JO
    $POUSPMMFST
    4FSWJDFT
    BOE
    .PEFMT
    BSF
    OPSNBM JNQMJDJU
    XBZ
    w $POT
    w .JTTJOH
    DPOOFDUJPO
    TXJUDIJOH
    DBO
    DBVTF
    USBHFEZ
    w *O
    RVFVFE
    KPCT
    w *G
    SVOOJOH
    PO
    TIBSFEFWFSZUIJOH
    JOGSBTUSVDUVSF
    MJLF
    'SBOLFO
    QIQ
16. )PX
    UP
    VTF
    3-4
    XJUI
    %PDUSJOF w %PDUSJOF
    BMTP
    BMMPXT
    NVMUJQMF
    DPOOFDUJPOT
    POMZ
    TUBUJD
    w 4BNF
    BT
    &MPRVFOU
17. )PX
    UP
    VTF
    3-4
    XJUI
    %PDUSJOF
18. )PX
    UP
    VTF
    3-4
    XJUI
    %PDUSJOF
19. )PX
    UP
    VTF
    3-4
    XJUI
    %PDUSJOF w 1SPT
    w $BO
    FBTJMZ
    DPOUSPM
    DPOOFDUJPO
    TXJUDIJOH FYQMJDJU
    XBZ
    w $POT
    w 4IPVME
    DIPPTF
    QSPQFS
    &OUJUZ.BOBHFS
    CFGPSF
    FWFSZ
    RVFSZ
    FYFDVUJPO
20. 5FBNT
    EFDJTJPO w FBTZ
    WT
    TJNQMF
    w JNQMJDJU
    WT
    FYQMJDJU
21. 5FBNT
    EFDJTJPO
    %PDUSJOF w FBTZ
    WT
    TJNQMF
    w JNQMJDJU
    WT
    FYQMJDJU
22. 5FBNT
    EFDJTJPO
    %PDUSJOF w WT
    &MPRVFOU
    w FYQMJDJU
    w FYQBOEBCJMJUZ
    w IUUQTHJUIVCDPNXFCEPDUSJOFQPTUHSFTRMSPXMFWFMTFDVSJUZ
    
    w WT
    1%0
    w DPEF
    DPNQMFUJPO
    XIFO
    DPEJOH
    w *%&
    TVQQPSU
    XIFO
    SFBEJOH
    w RVFSZ
    CVJMEFS
    CFOF fi U
23. 5FBNT
    EFDJTJPO
    )PX
    3-4
    XJUI
    %PDUSJOF
    XBT
    MJLF
    JO
    
    ZFBST w GFFMJOH
    w HFOFSBMMZ
    DPNGPSUBCMF
    XIFO
    SFBEJOH
    
    XSJUJOH
    w EFQMPZ
    w BT
    FBTZ
    BT
    TJOHMF
    UFOBOU
    w DPTU
    w BT
    MPX
    BT
    TJOHMF
    UFOBOU
    w XBSOJOH
    w DIFDL
    fi SNMZ
    JT
    UIJT
    UBCMF
    XJUI
    PS
    XJUIPVU
    3-4 
    w 'FBUVSF
    PS
    'VODUJPOBM
    UFTUT
    XJUI
    NVMUJUFOBOU
    EBUB
    XJMM
    IFMQ
    w BMTP
    IUUQTHJUIVCDPNXFCEPDUSJOFQPTUHSFTRMSPXMFWFMTFDVSJUZ
    XJMM
    IFMQ
24. 5IBOL
    ZPV