I'm dealing with a migration of a django site, and I'd like make all tables read-only except for the django_session table. How can I do this?

<pre class="prettyprint"><code>REVOKE INSERT, UPDATE, DELETE, TRUNCATE ON ALL TABLES IN SCHEMA public FROM public, <target_role>; </code></pre> Possibly add more roles to the list, but do not forget the role <code>public</code>. Possibly add more schemas to the list, but do not forget the schema <code>public</code>. Details in the manual. Superusers (like <code>postgres</code>) ignore permissions. A trigger would be an alternative to include them, too.

How can I mark a table read-only?

1 Answers

REVOKE INSERT, UPDATE, DELETE, TRUNCATE
ON ALL TABLES IN SCHEMA public
FROM public, <target_role>;

Possibly add more roles to the list, but do not forget the role public.
Possibly add more schemas to the list, but do not forget the schema public.
Details in the manual.

Superusers (like postgres) ignore permissions. A trigger would be an alternative to include them, too.