Show HN: Sqlauthz: Declarative permissions management for PostgreSQL
5 by camfeen67 | 0 comments on Hacker News.
I've been working on a little project recently to solve a problem that I've encountered at every job I've ever had, and I'm eager for some feedback. Having super granular roles & permissions in PostgreSQL is desirable, but quite difficult to maintain (particularly at smaller companies without dedicated security/devops/DBA/whatever who make it their business to maintain it). I've thought for a while that having a declarative way to manage them would be really useful and allow more teams to actually make use of sophisticated security features that PostgreSQL offers in their production systems. You can probably see where this is going... I wrote a tool to do just that! It's called sqlauthz, and it allows you to declarative manage your PostgreSQL permissions by writing rules in the Polar authorization language.
5 by camfeen67 | 0 comments on Hacker News.
I've been working on a little project recently to solve a problem that I've encountered at every job I've ever had, and I'm eager for some feedback. Having super granular roles & permissions in PostgreSQL is desirable, but quite difficult to maintain (particularly at smaller companies without dedicated security/devops/DBA/whatever who make it their business to maintain it). I've thought for a while that having a declarative way to manage them would be really useful and allow more teams to actually make use of sophisticated security features that PostgreSQL offers in their production systems. You can probably see where this is going... I wrote a tool to do just that! It's called sqlauthz, and it allows you to declarative manage your PostgreSQL permissions by writing rules in the Polar authorization language.