{"repo":"cfeenstra67/sqlauthz","free":true,"listed":false,"github":"https://github.com/cfeenstra67/sqlauthz","clone":"git clone https://github.com/cfeenstra67/sqlauthz.git","description":"Declarative permissions management for PostgreSQL","language":"TypeScript","stars":92,"topics":["declarative","oso","postgresql","postgresql-tool"],"license":"MIT","category":"databases-storage","readme_excerpt":"sqlauthz - Declarative permissions management for PostgreSQL sqlauthz allows you to manage your permissions in PostgresSQL in a declarative way using simple rules written in the Polar language. Polar is a language designed by Oso specifically for writing authorization rules, so its syntax is a great fit for declaring permissions. As an example of what this might look like, see the examples below: Currently sqlauthz support PostgreSQL as a backend, and it allows you to define: - Schema permissions - Table permissions including column and row-level security - View permissions - Function and procedure permissions - Sequence permissions To get started, check out the Table of Contents below. Table of Contents - Installation - Compatibility - CLI - CLI Configuration - User revoke strategies - Using sqlauthz as a library - Writing rules - Using SQL functions in row-level security clauses - Available constants - Permissions that depend on one another - Incremental Adoption - Examples - A complete example - Grant a user all permissions on all schemas - Grant a group of users all permissions on a schema - Grant a user read-only access on a schema - Grant a user read permissions on a limited set of rows and columns in a table - Integrating into a production application - Integrating into CI/CD - Integrating into tests - Considerations when using row-level security - Usage with VSCode - Oso Library Deprecation - Motivation - Limitations - Support and Feature Requests Installation sqlauth","default_branch":null,"files":null,"tree":[],"storefront":"/r/cfeenstra67","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/cfeenstra67/sqlauthz/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}