public inbox for [email protected]
help / color / mirror / Atom feeddisable create server
8+ messages / 4 participants
[nested] [flat]
* disable create server
@ 2020-03-26 22:26 Pavy Manuel <[email protected]>
0 siblings, 1 reply; 8+ messages in thread
From: Pavy Manuel @ 2020-03-26 22:26 UTC (permalink / raw)
To: [email protected] <[email protected]>
Hello,
I'm new in the pgadmin list.
I try to deploy pgadmin4 on my company but I want to manage the connections (server in pgadmin) the users can create.
So, I've found the line 84 of pgadmin/dashboard/templates/dashboard/welcome_dashboard.html to disable the link :
<a href="#" onclick="pgAdmin.Dashboard.add_new_server()">
, but I don't find how to disable the context menu in the right of the dashboard (each try has no impact on the application, perhaps caused by some cache or something like that).
Can someone help me please ? Is there any other way to do what I want ?
Thanks,
Manuel Pavy
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: disable create server
@ 2020-03-27 04:24 Khushboo Vashi <[email protected]>
parent: Pavy Manuel <[email protected]>
0 siblings, 1 reply; 8+ messages in thread
From: Khushboo Vashi @ 2020-03-27 04:24 UTC (permalink / raw)
To: Pavy Manuel <[email protected]>; +Cc: [email protected] <[email protected]>
Hi,
On Fri, Mar 27, 2020 at 3:56 AM Pavy Manuel <[email protected]> wrote:
> Hello,
>
> I'm new in the pgadmin list.
> I try to deploy pgadmin4 on my company but I want to manage the
> connections (server in pgadmin) the users can create.
> So, I've found the line 84 of
> pgadmin/dashboard/templates/dashboard/welcome_dashboard.html to disable the
> link :
> <a href="#" onclick="pgAdmin.Dashboard.add_new_server()">
>
> , but I don't find how to disable the context menu in the right of the
> dashboard (each try has no impact on the application, perhaps caused by
> some cache or something like that).
>
> Can someone help me please ? Is there any other way to do what I want ?
>
> I didn't get the idea of stopping users to create servers. If any user has
database access (may be limited) then he should be able to create it and
manage it as pgAdmin *just connects* the database with the given details in
the server dialog.
Thanks,
Khushboo
Thanks,
>
> Manuel Pavy
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: disable create server
@ 2020-03-27 10:31 Dave Page <[email protected]>
parent: Khushboo Vashi <[email protected]>
0 siblings, 1 reply; 8+ messages in thread
From: Dave Page @ 2020-03-27 10:31 UTC (permalink / raw)
To: Khushboo Vashi <[email protected]>; +Cc: Pavy Manuel <[email protected]>; [email protected] <[email protected]>
On Fri, Mar 27, 2020 at 4:24 AM Khushboo Vashi <
[email protected]> wrote:
> Hi,
>
> On Fri, Mar 27, 2020 at 3:56 AM Pavy Manuel <[email protected]> wrote:
>
>> Hello,
>>
>> I'm new in the pgadmin list.
>> I try to deploy pgadmin4 on my company but I want to manage the
>> connections (server in pgadmin) the users can create.
>> So, I've found the line 84 of
>> pgadmin/dashboard/templates/dashboard/welcome_dashboard.html to disable the
>> link :
>> <a href="#" onclick="pgAdmin.Dashboard.add_new_server()">
>>
>> , but I don't find how to disable the context menu in the right of the
>> dashboard (each try has no impact on the application, perhaps caused by
>> some cache or something like that).
>>
>> Can someone help me please ? Is there any other way to do what I want ?
>>
>> I didn't get the idea of stopping users to create servers. If any user
> has database access (may be limited) then he should be able to create it
> and manage it as pgAdmin *just connects* the database with the given
> details in the server dialog.
>
It seems like a reasonable request to me - for example, to stop students
adding random servers to a shared instance of pgAdmin that they're only
supposed to be using for coursework.
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: disable create server
@ 2020-03-27 10:34 Ashesh Vashi <[email protected]>
parent: Dave Page <[email protected]>
0 siblings, 1 reply; 8+ messages in thread
From: Ashesh Vashi @ 2020-03-27 10:34 UTC (permalink / raw)
To: Dave Page <[email protected]>; +Cc: Khushboo Vashi <[email protected]>; Pavy Manuel <[email protected]>; [email protected] <[email protected]>
On Fri, Mar 27, 2020 at 4:01 PM Dave Page <[email protected]> wrote:
>
>
> On Fri, Mar 27, 2020 at 4:24 AM Khushboo Vashi <
> [email protected]> wrote:
>
>> Hi,
>>
>> On Fri, Mar 27, 2020 at 3:56 AM Pavy Manuel <[email protected]> wrote:
>>
>>> Hello,
>>>
>>> I'm new in the pgadmin list.
>>> I try to deploy pgadmin4 on my company but I want to manage the
>>> connections (server in pgadmin) the users can create.
>>> So, I've found the line 84 of
>>> pgadmin/dashboard/templates/dashboard/welcome_dashboard.html to disable the
>>> link :
>>> <a href="#" onclick="pgAdmin.Dashboard.add_new_server()">
>>>
>> pgAdmin saves server list per user.
You may need to keep that in mind.
>
>>> , but I don't find how to disable the context menu in the right of the
>>> dashboard (each try has no impact on the application, perhaps caused by
>>> some cache or something like that).
>>>
>>> Can someone help me please ? Is there any other way to do what I want ?
>>>
>>> I didn't get the idea of stopping users to create servers. If any user
>> has database access (may be limited) then he should be able to create it
>> and manage it as pgAdmin *just connects* the database with the given
>> details in the server dialog.
>>
>
> It seems like a reasonable request to me - for example, to stop students
> adding random servers to a shared instance of pgAdmin that they're only
> supposed to be using for coursework.
>
Agreed.
-- Thanks, Ashesh
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: disable create server
@ 2020-03-27 12:41 Pavy Manuel <[email protected]>
parent: Ashesh Vashi <[email protected]>
0 siblings, 1 reply; 8+ messages in thread
From: Pavy Manuel @ 2020-03-27 12:41 UTC (permalink / raw)
To: Ashesh Vashi <[email protected]>; Dave Page <[email protected]>; +Cc: Khushboo Vashi <[email protected]>; [email protected] <[email protected]>
Thank you all.
I try to deploy pgadmin4 on my company but I want to manage the connections (server in pgadmin) the users can create.
So, I've found the line 84 of pgadmin/dashboard/templates/dashboard/welcome_dashboard.html to disable the link :
<a href="#" onclick="pgAdmin.Dashboard.add_new_server()">
pgAdmin saves server list per user.
You may need to keep that in mind.
Yes I’m aware of that
It seems like a reasonable request to me - for example, to stop students adding random servers to a shared instance of pgAdmin that they're only supposed to be using for coursework.
Agreed.
My need is different : I deploy pgadmin4 in an ansible role which deploy the following (inside the [ ] ) :
User ----> [ Apache ---> pgadmin ----> pgbouncer ] -----> postgresql backend
And I have a script for adding a server for a specific user which create a pool and add the server tuple in the sqlite3 db.
The benefit is :
- I can serialize the connections (some users open many, many tabs)
- users who do not close their connections are not a problem (thanks to the pgbouncer timeout)
- I can reserve some connection to the production chain
- I can monitor the pool
Since yesterday, I’ve found a (ugly) solution : in the ./pgadmin/static/js/generated/browser_nodes.js, I deactivate the Server action.
But the pretty way should be to create a dedicated profile (in addition of administrator and user).
Manuel Pavy
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: disable create server
@ 2020-03-30 03:35 Khushboo Vashi <[email protected]>
parent: Pavy Manuel <[email protected]>
0 siblings, 1 reply; 8+ messages in thread
From: Khushboo Vashi @ 2020-03-30 03:35 UTC (permalink / raw)
To: Pavy Manuel <[email protected]>; +Cc: Ashesh Vashi <[email protected]>; Dave Page <[email protected]>; [email protected] <[email protected]>
Hi,
On Fri, Mar 27, 2020 at 6:11 PM Pavy Manuel <[email protected]> wrote:
>
>
> Thank you all.
>
>
>
> I try to deploy pgadmin4 on my company but I want to manage the
> connections (server in pgadmin) the users can create.
> So, I've found the line 84 of
> pgadmin/dashboard/templates/dashboard/welcome_dashboard.html to disable the
> link :
> <a href="#" onclick="pgAdmin.Dashboard.add_new_server()">
>
> pgAdmin saves server list per user.
>
> You may need to keep that in mind.
>
>
>
> Yes I’m aware of that
>
>
>
>
>
> It seems like a reasonable request to me - for example, to stop students
> adding random servers to a shared instance of pgAdmin that they're only
> supposed to be using for coursework.
>
> Agreed.
>
>
>
> My need is different : I deploy pgadmin4 in an ansible role which deploy
> the following (inside the [ ] ) :
>
> User ----> [ Apache ---> pgadmin ----> pgbouncer ] -----> postgresql
> backend
>
> And I have a script for adding a server for a specific user which create a
> pool and add the server tuple in the sqlite3 db.
>
> The benefit is :
>
> - I can serialize the connections (some users open many, many tabs)
>
> - users who do not close their connections are not a problem (thanks to
> the pgbouncer timeout)
>
> - I can reserve some connection to the production chain
>
> - I can monitor the pool
>
>
>
> Since yesterday, I’ve found a (ugly) solution : in the
> ./pgadmin/static/js/generated/browser_nodes.js, I deactivate the Server
> action.
>
>
>
> But the pretty way should be to create a dedicated profile (in addition of
> administrator and user).
>
Please create a feature request @
https://redmine.postgresql.org/projects/pgadmin4 .
Thanks,
Khushboo
>
>
> Manuel Pavy
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* RE: disable create server
@ 2020-03-30 09:05 Pavy Manuel <[email protected]>
parent: Khushboo Vashi <[email protected]>
0 siblings, 1 reply; 8+ messages in thread
From: Pavy Manuel @ 2020-03-30 09:05 UTC (permalink / raw)
To: Khushboo Vashi <[email protected]>; +Cc: Ashesh Vashi <[email protected]>; Dave Page <[email protected]>; [email protected] <[email protected]>
Hello,
But the pretty way should be to create a dedicated profile (in addition of administrator and user).
Please create a feature request @ https://redmine.postgresql.org/projects/pgadmin4
Done : https://redmine.postgresql.org/issues/5301
Manuel Pavy
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: disable create server
@ 2020-03-30 09:06 Khushboo Vashi <[email protected]>
parent: Pavy Manuel <[email protected]>
0 siblings, 0 replies; 8+ messages in thread
From: Khushboo Vashi @ 2020-03-30 09:06 UTC (permalink / raw)
To: Pavy Manuel <[email protected]>; +Cc: Ashesh Vashi <[email protected]>; Dave Page <[email protected]>; [email protected] <[email protected]>
On Mon, Mar 30, 2020 at 2:35 PM Pavy Manuel <[email protected]> wrote:
> Hello,
>
>
>
> But the pretty way should be to create a dedicated profile (in addition of
> administrator and user).
>
> Please create a feature request @
> https://redmine.postgresql.org/projects/pgadmin4
>
>
>
> Done : https://redmine.postgresql.org/issues/5301
>
>
>
Thanks.
> Manuel Pavy
>
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2020-03-30 09:06 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-03-26 22:26 disable create server Pavy Manuel <[email protected]>
2020-03-27 04:24 ` Khushboo Vashi <[email protected]>
2020-03-27 10:31 ` Dave Page <[email protected]>
2020-03-27 10:34 ` Ashesh Vashi <[email protected]>
2020-03-27 12:41 ` Pavy Manuel <[email protected]>
2020-03-30 03:35 ` Khushboo Vashi <[email protected]>
2020-03-30 09:05 ` Pavy Manuel <[email protected]>
2020-03-30 09:06 ` Khushboo Vashi <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox