kgb=# create schema s1; CREATE SCHEMA kgb=# create user mary; CREATE ROLE kgb=# revoke all on schema s1 from mary; REVOKE kgb=# create table s1.testing (id int); CREATE TABLE kgb=# \c kgb mary kgb=> set search_path=s1; SET kgb=> \dt No relations found. kgb=> select * from s1.testing; ERROR: permission denied for schema s1 kgb=>