Fine-grained sharing of database connections

Aberta
#9,538 2 comentários 0 reações 1 responsável Ver no GitHub

Mantenedores costumam responder em até 2 dias

@schaerfo já está trabalhando nisso.

Desde 16/1/2026.

Avaliação

Esta issue ainda não foi avaliada.

Descrição

Feature

Describe the solution you'd like

As of now, database connections can be shared with either none or all users. It would be useful to be able to share database connections only with selected users.

In my case, some maintenance tasks must be performed manually on the database. I would like to add database connections that use PostgreSQL roles with the required permissions and share them with the respective authorized pgadmin users. Then, the users can log into pgadmin using OAuth2 and access the database with their respective permissions without access to database credentials.

For compatibility with existing installations, it would probably be best to not re-purpose the notion of ‘roles’ and instead implement user groups to which users can be added. Then, database connections can be shared with selected groups.

Describe alternatives you've considered

Alternatively, users could log into pgadmin with PostgreSQL roles, bypassing the user management of pgadmin (this was suggested in #6939).

Additional context

Similar proposals have been put forward in the past, e.g. #5534

I would be willing to try and implement this if it gets approved.

Linguagem predominante
Python
Estrelas
3.9k
Forks
922
Merge médio
2d 3h
PRs com merge (30d)
33

Preparar o ambiente

Primeiros passos

  1. Leia a issue inteira e depois o guia de contribuição do projeto.
  2. Comente na issue dizendo que vai assumir — evita que duas pessoas façam o mesmo trabalho.
  3. Faça um fork do repositório e trabalhe em uma branch.
  4. Abra um pull request que referencie o número da issue.

Mais de pgadmin-org/pgadmin4

Todas as issues de pgadmin-org/pgadmin4

Issues semelhantes

Mais issues de Python

Receba novas issues na sua caixa de entrada

Um resumo curto de issues do GitHub para quem está começando.