Chris Travers <chris@travelamericas.com> writes:
> Adding every table as a view is not going to be likely to be feasible
> since it will involve a major maintenance nightmare. Depending on
> requirements, we may look at allowing most of the database to be
> readable to all users, but this is not ideal and I am looking for
> maintainable workarounds.
Is it really not possible to express what you need with plain old SQL
permissions? It seems like you are going out of your way to avoid the
obvious solution.
regards, tom lane