Re: Making a schema "read-only" (was Unexpected message in grant/revoke script) - Mailing list pgsql-general

>  >  Start with
>  >         revoke all on schema public from public
>  >  and then grant only what you want.

Oh -- to grant select permissions on all the tables in the public
schema, do I have to do it table-by-table?  I know I can write a loop
an use information_schema if necessary, but if I don't have to I would
like to know.

Thx