By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
select current_user;
create role administrator;
grant all on schema public to administrator;
create role test_user;
| current_user |
|---|
| postgres |
SELECT 1
CREATE ROLE
GRANT
CREATE ROLE
set role administrator;
create table test(id int);
insert into test values(1);
SET
CREATE TABLE
INSERT 0 1
set role test_user;
insert into test values(2);
SET
ERROR: permission denied for table test
set role postgres;
grant administrator to test_user with inherit false;
SET
GRANT ROLE
set role test_user;
insert into test values(2);
SET
ERROR: permission denied for table test
set role postgres;
grant administrator to test_user with inherit true;
SET
GRANT ROLE
set role test_user;
insert into test values(2);
SET
INSERT 0 1