pgperms: Declarative / config as code for PostgreSQL permissions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


Hey all,

I wrote a tool that can manage PostgreSQL permissions from a config file. The config file describes your desired roles and grants and syncs them to your PostgreSQL cluster. This allows you to manage your permissions in Git, for example.

You can find detailed instructions and the binaries at

Here's some example config to show its features:

    password: SCRAM-SHA-256$4096:...
    createdb: true
- mydatabase
- mydatabase.myschema
- roles: [yourname]
  privileges: [CONNECT, TEMPORARY]
  databases: [mydatabase]
- roles: [yourname]
  privileges: [CREATE, USAGE]
  schemas: [mydatabase.myschema]
- roles: [yourname]
  privileges: [SELECT, INSERT, UPDATE]
  tables: [mydatabase.otherschema.*]

Let me know if you find any bugs or need any missing features. It'd be great to hear people find this useful :)

-- Jille
Development of pgperms is sponsored by SnoozeThis: a bot that can hold on to your blocked issues until they're actionable (

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux