Squarespace / pgbedrock

Manage a Postgres cluster's roles, role memberships, schema ownership, and privileges
https://pgbedrock.readthedocs.io/en/latest/
Other
311 stars 35 forks source link

Add restrict list option to pgbedrock configuration #53

Closed dmoore1989 closed 4 years ago

dmoore1989 commented 4 years ago

The purpose of this pull request is to allow users to restrict tables and sequences when they add privileges for the entire schema (using schema_name.*). This will allow the user to blacklist tables that they do want to include in the standard privilege list instead of just the standard

Users can add these restricted tables by doing the following in the configuration yaml file:

 user:
            privileges:
                tables:
                    read:
                        - schema0.*
                    restrict:
                        - schema0.table2 // user can read all tables except for table 2 in schema 0
coveralls commented 4 years ago

Pull Request Test Coverage Report for Build 189


Files with Coverage Reduction New Missed Lines %
/opt/pgbedrock/spec_inspector.py 14 94.44%
<!-- Total: 14 -->
Totals Coverage Status
Change from base Build 179: -0.8%
Covered Lines: 2550
Relevant Lines: 2644

💛 - Coveralls