Re: Schemas and access

> 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
> plugh. JoeBob has run
>
> GRANT SELECT on xyzzy.plugh TO public;
>
> JoeBob and MaryJo can both show permissions:
>
> joebob=> \z zyzzy.*
> Access privileges for database "joebob"
> Schema | Table | Access privileges
> --------+--------+--------------------
> xyzzy | plugh | {=r,joebob=arwdRxt}
>
> JoeBob can do anything with the table, that works. But MaryJo can't
> even select:
>
> 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.

I think there is a "greant usage on schema" type statement that you
probably need.