felix-lists@crowfix.com writes:
> joebob=> select * from xyzzy.plugh;
> ERROR: xyzzy: permission denied
> It sure looks like the schema itself is invisible to MaryJo, but
> MaryJo can run \dt xyzzy.* perfectly fine.
You need to grant USAGE permission on the schema to MaryJo.
We've seen this mistake often enough that I wonder if maybe schemas
should default to granting USAGE permission to public ...
regards, tom lane