On Wed, 2008-11-05 at 15:46 -0800, Webb Sprague wrote:
> Hi all
>
> Is there a away to set up a schema such that a certain role has (1)
> read only access to (2) all the tables, but (3) must use predefined
> functions to use that access?
you can set transactions read only but the user can turn them off. Use
views, functions and GRANT.
Joshua D. Drake
--