rverghese schrieb am 11.10.2017 um 20:38:
> You mean at the user permissions level? Yes, I could, but would mean doing so
> table by table, which is not our current structure. I guess there is nothing
> at the database level.
Not at the database level, but at the schema level:
You can revoke those privileges for all tables in a schema:
revoke insert,update,delete on all tables in schema public from the_user;
You can do that for all future tables as well:
alter default privileges in schema public revoke insert,update,delete on tables from the_user;
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general