| From: | chiru r <chirupg(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, John R Pierce <pierce(at)hogranch(dot)com>, Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_basebackup issue |
| Date: | 2017-04-23 03:04:17 |
| Message-ID: | CA+RSxMhEgqaSQCF_W2TnKEahP59toV+zn8wrWaFHBfZ6spujYw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Use case: Want to control database privileges/default roles by creating
roles instead of granting directly to users.
So that we can manage database access control easily.
Thanks,
Chiru
On Sat, Apr 22, 2017 at 10:03 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Saturday, April 22, 2017, chiru r <chirupg(at)gmail(dot)com> wrote:
>
>> Thank you Adrian.
>>
>> It seems the code is allowing only who has Superuser/Replication role
>> directly.
>>
>> Is there any possibility in future releases they allow both case A & B
>> Users able to use pg_basebackup.
>>
>>
> It does not seem wise to introduce inheritance of such
> powerful capabilities when for many years now we have not done so. It
> seems like reality could be better documented but the present behavior
> should stay. I also find the original choice to be quite sane regardless.
>
> David J.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2017-04-23 04:10:12 | Re: pg_basebackup issue |
| Previous Message | David G. Johnston | 2017-04-23 02:03:03 | Re: pg_basebackup issue |