Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-17 Thread Владимир Янченко
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 othe

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
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

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Guillaume Lelarge
Le 16 déc. 2015 2:11 PM, "Nikolai Zhubr" a écrit : > > Hello, > 16.12.2015 14:32, Владимир Янченко: > >> Adam, >> >> yes, you're right. I can connect via PSQL, but get error in PSQL, when I >> try to list databases. >> >> That's what I need, because I don't want show all users and all >> databases

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
l.org <mailto:pgadmin-support@postgresql.org> *Subject:* Re: [pgadmin-support] Connection by user with restricted access to pg_database Nikolai, thank you for your answer. I expect that pgadmin connects to my database and I can execute some sql queries to get data. Bu

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Adam Pearson
Cc: Nikolai Zhubr; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Connection by user with restricted access to pg_database Adam, yes, you're right. I can connect via PSQL, but get error in PSQL, when I try to list databases. That's what I need, because I don't want

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Владимир Янченко
ermissions back and try again. > > > > Regards, > > Adam Pearson > > > > *From:* pgadmin-support-ow...@postgresql.org [mailto: > pgadmin-support-ow...@postgresql.org] *On Behalf Of * ??? > *Sent:* 16 December 2015 11:04 AM > *To:* Nikolai Zhubr >

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Adam Pearson
: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] Connection by user with restricted access to pg_database Nikolai, thank you for your answer. I expect that pgadmin connects to my database and I can execute some sql queries to get data. But instead I get window with error about

Re: [pgadmin-support] Connection by user with restricted access to pg_database

2015-12-16 Thread Nikolai Zhubr
Hello, 16.12.2015 10:04, Владимир Янченко: [...] 2015-12-15 15:33:54 ERROR : ERROR: permission denied for relation pg_database 2015-12-15 15:33:55 ERROR : ERROR: permission denied for relation pg_tablespace 2015-12-15 15:33:56 ERROR : ERROR: permission denied for relation pg_roles 2015-12-1

[pgadmin-support] Connection by user with restricted access to pg_database

2015-12-15 Thread Владимир Янченко
Hi! We provide access for our customers to their databases. These databases located on the same postgresql cluster, that's why we denied access to pg_database, pg_roles and others to client's users. One of our customer uses pg_admin. He can't connect to database by provided username because there