Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

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