-
Notifications
You must be signed in to change notification settings - Fork 797
Description
Describe the bug
There are several issues related to managing privileges in pgAdmin for both PostgreSQL and EPAS.
To Reproduce
Steps to reproduce the behavior on EPAS and PostgreSQl:
Database -> Default Privileges -> Tables
Error: When creating privileges for DATABASE -> Default Privileges -> Tables, the following error occurs:
syntax error at or near "GRANT"
LINE 2: GRANT INSERT, SELECT ON TABLES TO testdb;
^
Database -> Default Privileges -> Sequences and Functions
- When creating the first privilege and saving, reopening the properties shows multiple auto-created privileges.
- When updating the grantee of an existing privilege and saving, it creates a new privilege instead of updating the existing one.
Database -> Default Privileges -> Types
- When creating and saving privileges for types, reopening the properties shows that the privileges are missing or removed automatically.
(FYI:- SQL for type privileges is not generated.)
Schema -> Default Privileges -> Any Privileges
- When updating an existing privilege, it creates a new privilege instead of updating the existing one.
Materialized Views, Views, Foreign Tables, and Partitions
- When updating an existing privilege, it updating an existing privilege creates a new privilege rather than modifying the existing one.
UI/UX Issue with Privileges Dropdown
- The Privileges dropdown input box appears like non-editable but is editable.
- The dropdown functionality is unclear as it does not display the dropdown arrow, leading to confusion for users.
EPAS-Specific Issue:
Schema -> Default Privileges -> Privileges
When creating a privilege on a schema and saving it, reopening the privilege shows that it has been updated its WITH GRANT OPTION automatically.
Desktop (please complete the following information):
- OS: MacOS Sequoia 15.0.1
- Version: 8.14 (snapshot)
- Mode: Server
- Browser :- Chrome
- Package type: wheel