| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Nikolai Zhubr <n-a-zhubr(at)yandex(dot)ru> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Connection by user with restricted access to pg_database |
| Date: | 2015-12-16 13:37:39 |
| Message-ID: | CAECtzeWPGYXkYTn_C036ab_AqsCMS63Ru4K_tm+sbkQbx9dY0w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Le 16 déc. 2015 2:11 PM, "Nikolai Zhubr" <n-a-zhubr(at)yandex(dot)ru> 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 to our client, who will be connected by this restricted user.
>>
>> My goal: user CAN NOT view pg_databases and pg_roles, but CAN connect to
>> his database via pgadmin and execute sql statements.
>
>
> I like the idea. Not sure if it is reasonably possible to implement this
and how much effort it would take though. (I never got that deep yet)
>
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolai Zhubr | 2015-12-16 15:09:45 | Re: Connection by user with restricted access to pg_database |
| Previous Message | Nikolai Zhubr | 2015-12-16 13:08:45 | Re: Connection by user with restricted access to pg_database |