Skip to content

Instantly share code, notes, and snippets.

View mattbretl's full-sized avatar

Matt Bretl mattbretl

View GitHub Profile

Keybase proof

I hereby claim:

  • I am mattbretl on github.
  • I am mattbretl (https://keybase.io/mattbretl) on keybase.
  • I have a public key ASAXQO0m64V94CF7RrBK2xOW15F1c7pcMTsikBy5DZW2Jgo

To claim this, I am signing this object:

@mattbretl
mattbretl / information_schema_role_inheritance.sql
Last active December 7, 2017 12:26
Strange behavior with inherited role permissions in information_schema
-- With this schema in place..
-- https://github.com/postgraphql/postgraphql/blob/master/examples/forum/schema.sql
-- try running the following:
set role forum_example_postgraphql;
select distinct privilege_type from information_schema.role_table_grants where table_name = 'person';
-- privilege_type
------------------
-- DELETE