Re: Admin User Connect Privilege to Database

Поиск
Список
Период
Сортировка
От richard coleman
Тема Re: Admin User Connect Privilege to Database
Дата
Msg-id CAGA3vBv5Ex3xYwcK_7bvZ=uoi_dox54CV_PwrEEdwwcxpQznog@mail.gmail.com
обсуждение исходный текст
Ответ на Admin User Connect Privilege to Database  (Josh Klok <josh.klok88@gmail.com>)
Список pgadmin-support
Дерево обсуждения
Josh, 

This isn't really the list for it, but have you tried:

GRANT CONNECT ON DATABASE database_name TO public;
as the postgres superuser?

just a thought, 
rik.

 

On Thu, Jun 29, 2023 at 3:41 PM Josh Klok <josh.klok88@gmail.com> wrote:
Hi,

I'm relatively new to database management. I have a database setup currently with a few users. While configuring the user privileges within the database, I inadvertently removed the CONNECT privilege from all users (including the admin user). 

image.png
Can you let me know how to re-enable the CONNECT privilege for all users?

Thanks

-Josh K
Вложения

В списке pgadmin-support по дате отправления:

Предыдущее
От: Josh Klok
Дата:
Сообщение: Admin User Connect Privilege to Database
Следующее
От: Roberto Tagliaferri - Tosnet srl
Дата:
Сообщение: Re: pgAdmin 4 v7.4 Released