Roberts, Jon wrote:
> I need a "grant select on <dbname> to <rolename>".
>
>
This is a FAQ, though it doesn't actually seem to be in the PostgreSQL FAQ.
A Google search, either of the mailing list archives or of the web in
general, for:
postgresql grant all tables
should prove informative.
http://www.google.com/search?q=postgresql+grant+all+tables
http://www.google.com/search?q=postgresql+grant+all+tables+site%3Aarchives.postgresql.org
--
Craig Ringer