| From: | Alan Droege <adroege(at)perfectpractice(dot)com> |
|---|---|
| To: | pgadmin-support(at)postgresql(dot)org, adroege(at)adclegal(dot)com |
| Subject: | Permission error causes object tree to be built incomplete |
| Date: | 2016-03-02 19:02:50 |
| Message-ID: | 0100015338b61645-cdad9159-20b8-4227-9131-f5387ae813b5-000000@email.amazonses.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
I have removed SELECT rights from the pg_proc.prosrc column so that I
can hide
the source code of stored functions. This is working OK.
However when logging into to PgAdmin, when the following error occurs
(which is expected)
>>An error has occurred:
>>ERROR: permission denied for relation pg_proc
the rest of the display tree is not built correctly. The "Tables"
object shows (0). I suspect the error
is not being handled gracefully, and other catalog queries are not being
processed as they should.
I would like users to be able to see everything in the graphical tree
that they are allowed to see. Is there
a work-around, or can this be addressed as a bug-fix in a future release?
I have tried pgAdmin 1.18.1 and also 1.22.0
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | johannes graën | 2016-03-06 17:35:00 | Re: Copy & paste key commands not working correctly |
| Previous Message | Shailesh Doshi | 2016-03-02 18:14:13 | pgAdmin3 1.2.X install on OSX - hangs with CPU at 100% |