[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
