Re: Connection by user with restricted access to pg_database - Mailing list pgadmin-support

From Владимир Янченко
Subject Re: Connection by user with restricted access to pg_database
Date
Msg-id CAAH6kD1=qWcE-Aycx=-2b2tt8dtwXW1b=UkJ8PGoTVgsGfvUgg@mail.gmail.com
Whole thread Raw
In response to Re: Connection by user with restricted access to pg_database  (Nikolai Zhubr <n-a-zhubr@yandex.ru>)
List pgadmin-support
Thank you for the support.

In general I agree with Nikolai that it is helpful to have ability to use the navigation panel and other tools for my database when I haven't access to others.

I'm sure that my case is impossible in the current pgadmin version. After all searches I suggested to use other tools to the customer.

We opened that some other tools (razorsql, sql developer, navicat, etc) have the same behavior. Then we finally found a suitable tool.

2015-12-16 20:09 GMT+05:00 Nikolai Zhubr <n-a-zhubr@yandex.ru>:
Hello,
16.12.2015 16:37, Guillaume Lelarge:
[...]

Would be quite difficult. And I completely dislike the idea.

If you only need the SQL editor, you can already do this by launching
PgAdmin directly with the SQL tool.

I'm not sure what you mean by "directly with the SQL tool"?
Anyway. It could be usefull not only for just typing SQL.
Even when access is essentially restricted to some specific database, the navigation panel could still be usefull to show objects within that specific database and fetch their properties etc. This is done through pg_catalog so it should work fine I suppose? I actually can't see what's so wrong with this setup (other than someone would obviously have to spend some time and effort to develop patches) In fact, that is exactly the usage pattern I have with pgadmin most of the time: connect to a specific database and _stay_ _within_ that database.


Regards,
Nikolai



--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

pgadmin-support by date:

Previous
From: Nikolai Zhubr
Date:
Subject: Re: Connection by user with restricted access to pg_database
Next
From: Frank Gard
Date:
Subject: Strange behaviour concerning SAVEPOINTs