We have enterprise geodatabases on AWS RDS for Postgres/PostGIS. And the sde account is given the rds_superuser role. While accessing the RDS geodatabase from ArcGIS client using the SDE account, the SDE account is unable to disconnect logged-in users from the geodatabase connection. And the error message is "Insufficient Permissions" or "Connection information provided was for a non-administrative user".
In PostgreSQL, the sde account is given the superuser role, that is what is needed to be able to have the permissions to disconnect users. Not sure why rds_superuser role is not working as expected or whether I am missing something in the workflow.
Appreciate any insights or solutions to this.