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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
