sde account with rds_superuser role on AWS RDS Postgres has insufficient privileges to disconnect users

Question

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.

Thank you,

Henok

Bernd_Loigge · Answer

We are facing the same issue in azure (managed PG cloud DB - no superuser rights). Can you post the SQL statement for deleting the lock? Would be nice if ESRI would create a TroubleShooting for this kind of issue.

JeffreyOwen1 · Answer

Interesting. I am using ArcGIS Pro as well and have the same issue as with using the script. Is your setup the same? Amazon RDS PostgreSQL database?

After talking to Esri they suggest that I use PGAdmin and run a SQL statement to kill the processes by PID. That seemed to work but I am having other issues with my database unrelated to this as well, so who knows.

SteveTaylor5 · Answer

Hi Jefferey
I managed to disconnect users with the SDE user by using ArcGIS Pro and not ArcMap
It seems ArcGIS Pro behaves differently and allows the SDE user to disconnect other connections and ArcMap just reports and Insufficient Privileges error.