Introducing Neon Authorize: Simplifying Row-Level Security For Postgres

Neon Authorize is a new tool that simplifies the usage of Postgres row-level security (RLS) policies, enabling developers to manage RLS directly in their codebase and integrate with any authentication provider. This feature allows for fine-grained access control without added complexity. With Neon Authorize, calls to the database can be authenticated with a JWT generated by the auth provider, which is verified by the Neon Proxy and made available for RLS rules and WHERE clauses alike. The tool also offers utility functions such as auth.session() and auth.user_id(). In partnership with Drizzle ORM, developers can set up RLS policies in a declarative format right alongside their schema definitions, making the codebase more organized and easier to maintain.