这是indexloc提供的服务,不要输入任何密码
Skip to content

Default Privileges and Privileges not working correctly. #8369

@RohitBhati8269

Description

@RohitBhati8269

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

  1. When creating the first privilege and saving, reopening the properties shows multiple auto-created privileges.
  2. 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

  1. 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

  1. When updating an existing privilege, it creates a new privilege instead of updating the existing one.

Materialized Views, Views, Foreign Tables, and Partitions

  1. 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

  1. The Privileges dropdown input box appears like non-editable but is editable.
  2. 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

Metadata

Metadata

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions