pgadmin4
pgadmin4 copied to clipboard
schema diff: grant & revoke
schema diff suggests this nonsense to me:
REVOKE ALL ON TABLE schema1.table1 FROM user1;
GRANT ALL ON TABLE schema1.table1 TO user1;
Note that source and target are different databases. Perhaps a user oid problem (i. e. username is the same, but user oids are different)?