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?
I do not find any document which says that inheritance does not work with
roles which have superuser role granted to it. Note that rdsdba is not a
superuser in itself, but only has a role which is superuser.
--
Thanks in advance.