[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 mi
> I am just beginning to investigate schemas, and have run into a
> problem. Searching the mailing lists and documentation doesn't help.
>
> This is 7.3.3 on Linux, kernel 2.4.21, good ole Slackware, compiled
> from source.
>
> Two users, JoeBob and MaryJo. JoeBob has schema xyzzy with table
> pl
