Jeff Davis <pg...@j-davis.com> writes: > My idea is to have a "GRANT mask": > CREATE ROLE foo_ro GRANT (SELECT ON TABLE, USAGE ON SCHEMA) FROM foo;
You haven't really explained what "foo" is here. If it's a single object then I don't think this offers any leverage. If it's a placeholder or class representative of some kind, then maybe, but in that case you've entirely failed to convey the point ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers