Of the many things I love about Fauna, the one that first comes to mind is its security model. I just released an app. In its earliest stages I had an incomplete understanding of what I wanted to achieve, so I started with what I knew: it had to have user authentication. Afterwards, I just concentrated on writing all the parts that make it work, without any more thought of security. In the end, I had something special. It became clear that it was community-based, where sharing one’s work was paramount, but I wanted to ensure that no one could modify my work, only view it. At that moment, the security model was clear, and roles quickly followed.
My question is: “How does Fauna’s security model compare to other vendors, specifically MS SQL Server?” It has been about 8 years since I last worked with SQL Server. My recollection was that it couldn’t “hold a candle” to Fauna, by comparison. Is this still true, today?