[pgpool-general: 6050] Access to pgpool set from an unprivileged	user
    Vlad G 
    omenvlad at gmail.com
       
    Mon Apr 23 20:07:04 JST 2018
    
    
  
Hey Guys, 
I have a cluster with md5 authentication.
Pgpool-II-pg96-3.7.3 and postgresql-9.6.
I created the user "testing" and the database "testing"
This user has only permissions for this database, but I  found out that this user can 
change pgpool's parameters  if I do for example:
testing=> PGPOOL set client_idle_limit = 30;
SET
testing=> PGPOOL SHOW client_idle_limit;
client_idle_limit 
-------------------
30
(1 row)
How can I reduce permissions for this user and forbid access to "pgpool set" commands?
Best regards,
Vladyslav
    
    
More information about the pgpool-general
mailing list