Re: Noinheritance with superuser

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: saket bansal <saket(dot)tcs(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Noinheritance with superuser
Date: 2021-06-04 03:59:12
Message-ID: 118646.1622779152@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

saket bansal <saket(dot)tcs(at)gmail(dot)com> writes:
> I have an RDS instance with the below configuration.
> create role role1 login noinheritance;
> grant rds_superuser to rdsdba;
> grant rdsdba to role1

> In this case role1 is able to do all administrative operations, without the
> need of switching to rdsdba.
> Is this expected?

rds_superuser is not a thing that exists in community Postgres.
I'd suggest taking this question up with the Amazon RDS folk.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-06-04 04:04:00 Re: Please tell me about character code conversion.
Previous Message 久門 愛 2021-06-04 03:32:27 Please tell me about character code conversion.