[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