Friday, June 15, 2012

Postgresql 9 - some reminder


1. Grant select only to a certain user on tables.

psql databasename

GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonlyuser;