Hi all, I've noticed Grant Wizard (schema node) generates odd SQL to grant privileges on sequence. Sequence is treated as a table, so SQL may look like this:
GRANT SELECT, UPDATE, INSERT, DELETE, REFERENCES ON TABLE "MySchema"."MySeq" TO "MyGroup"; what produces warning message: WARNING: sequence "MySeq" only supports USAGE, SELECT, and UPDATE privileges Of course SELECT is granted :) My suggestion is to change this behavior to produce SQL dedicated to sequence: GRANT SELECT ON SEQUENCE "MySchema"."MySeq" TO "MyGroup"; Without (INSERT, UPDATE, etc). Also there is no USAGE option available in Grant Wizard window (schema node only). env pgAdmin 1.16.1 on Windows. Regards, Bartek
