if i want to perform a grant on all of the tables in a database to an
individual or group, is there a way to do that? right now i'm trying to
use...
grant all on
(select tablename from pg_tables where tablename not like 'pg%')
to groupName;
but i get parsing errors (even if i remove the parens). is there an easy way
to do this? can i grant priveleges on a database? that isn't in the momjian
book as being a valid target object...
rjsjr