Skip to main content
1 of 4

DENY insert,update,delete to user (PostgreSQL)

I wonder if Postgre support the DENY command. I search in the documentation but i couldn't find anything about deny.

I have GRANT ALL ON table1 TO user1 WITH GRANT OPTION but i don't want user1 to be able to grant insert/update/delete to user2. (He can do whatever he want with everyone else!!!)

Is there any way to accomplish this?

Thanks!