search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.53k stars 656 forks source link

Default sequence privileges does not show update grant (RM #4087) #2448

Closed dpage closed 2 years ago

dpage commented 5 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/4087 Originally created by Michael Banck at 2019-03-15 14:31:00 UTC.

  1. Go to the public schema in a database, open the SQL tab.

  2. You see the usual SQL commands, ending with "GRANT ALL ON SCHEMA public TO PUBLIC;"

  3. Issue the command "ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT UPDATE ON SEQUENCES TO postgres;"

  4. The SQL tab has not changed even on refresh, the ALTER DEFAULT PRIVILEGES is not shown while a local \dpp in psql does show it

  5. Issue the command "ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT, UPDATE ON SEQUENCES TO postgres;"

  6. The SQL tab now shows the following on refresh, without UPDATE:

ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON SEQUENCES TO postgres;

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4087#note-1 Originally created by Michael Banck at 2019-03-15 14:32:54 UTC.

This is a regression from pgadmin3 where the DEFAULT PRIVILEGES for SEQUENCES where displayed correctly.

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4087#note-2 Originally created by Aditya Toshniwal at 2019-03-22 10:20:50 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4087#note-3 Originally created by Akshay Joshi at 2019-04-10 09:50:17 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready EDB Sprint 38
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4087#note-4 Originally created by Khushboo Vashi at 2019-04-22 05:47:33 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Khushboo Vashi
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4087#note-5 Originally created by Khushboo Vashi at 2019-04-22 06:21:19 UTC.

Patch sent. https://www.postgresql.org/message-id/CAFOhELcHn30bf=S-3810w7FcwZVGiYb1oxeaYd3roTGt10A6oA@mail.gmail.com

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4087#note-6 Originally created by Khushboo Vashi at 2019-04-22 06:54:58 UTC.

Applied in changeset commit:ecded183338192ff6110c8e16da6823511d9d6f9.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/4087#note-7 Originally created by Fahar Abbas at 2019-04-22 10:14:11 UTC.

This is Resolved in latest Commit (commit ecded183338192ff6110c8e16da6823511d9d6f9)

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.