[pgAdmin][RM5400] An unexpected occurred: INTERNAL SERVER ERROR message displayed if database server connected with non super user

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: [pgAdmin][RM5400] An unexpected occurred: INTERNAL SERVER ERROR message displayed if database server connected with non super user
Date: 2020-04-16 06:03:13
Message-ID: CAM9w-_kERYy9+ijZj9MLCRhv888HSAFyMZYKUo-4HU75q8BDzw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Hackers,

Attached is the patch to replace the usage of pg_user_mapping table with
pg_user_mappings view. pg_user_mapping is not publicly accessible.
Changes are done for search objects and foreign data wrappers.
pgAdmin throws an exception when accessing User mappings with non
privileged users.
More about pg_user_mappings -
https://www.postgresql.org/docs/9.5/view-pg-user-mappings.html

Please review.

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"

Attachment Content-Type Size
RM5400.patch application/octet-stream 11.1 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message navnath gadakh 2020-04-16 06:37:01 Re: [pgAdmin][RM5210] pgAdmin4 silently truncates text larger than underlying field size
Previous Message Ganesh Jaybhay 2020-04-16 05:04:49 Re: [pgAdmin][4709] Invalid FTS configuration token dictionaries