| From: | richard coleman <rcoleman(dot)ascentgl(at)gmail(dot)com> |
|---|---|
| To: | Josh Klok <josh(dot)klok88(at)gmail(dot)com> |
| Cc: | pgadmin-support(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Admin User Connect Privilege to Database |
| Date: | 2023-06-29 22:31:05 |
| Message-ID: | CAGA3vBv5Ex3xYwcK_7bvZ=uoi_dox54CV_PwrEEdwwcxpQznog@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(dot)klok88(at)gmail(dot)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: image.png]
> Can you let me know how to re-enable the CONNECT privilege for all users?
>
> Thanks
>
> -Josh K
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Tagliaferri - Tosnet srl | 2023-07-05 07:31:11 | Re: pgAdmin 4 v7.4 Released |
| Previous Message | Josh Klok | 2023-06-29 19:40:50 | Admin User Connect Privilege to Database |