pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

schema diff: grant & revoke

Open fjf2002 opened this issue 3 years ago • 0 comments

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)?

fjf2002 avatar Nov 02 '22 16:11 fjf2002