Unable to delete admin account in the console

Hey, I have a problem deleting one of our local admin users on InsightVM console. On the first try of deleting the user, the system recommended to transfer all existing reports to another user, and that is what I did. After that, there was no notification or so whether this was successfully done or not. Now when I try to delete the user, it just keeps saying “deleting” in the banner but nothing happens.

Any tips? Is there a way to force delete user from cmd?

Im also experiencing this. Have you got a resolution for this?

Apparently it is a “default account” created during the installation. Default account can’t be deleted. A fresh install of the console is needed if you need to get rid of the account.

See section “Default account creation”:

Coming back to this! There was a way that we logging into the database directly and had to delete user from the database itself. Support Engineer helped us through that process I can dig it up if there is still a need

Mind sharing please ?

hank you for providing the screenshot, the best step to resolve this issue is to remove the user directly by manipulating the database, and I’ve detailed the steps below on how to do this!
PLEASE NOTE: it is important to create a backup before directly manipulating the database, in the event that you may need to restore to the previous version.


LOGGING INTO DATABASE: From your host OS command line, follow these steps:

  1. Unlock the Database
    Change all the ‘md5’ entries to ‘trust’ in the pg_hba.conf file by running the command:
    sed -ibak ‘s/md5/trust/g’ /opt/rapid7/nexpose/nsc/nxpgsql/nxpdata/pg_hba.conf

  2. Reload Database:
    Reloading the database config can only be done when no scans are in progress, you can run the following command:
    sudo -u nxpgsql /opt/rapid7/nexpose/nsc/nxpgsql/pgsql/bin/pg_ctl -D /opt/rapid7/nexpose/nsc/nxpgsql/nxpdata reload

  3. Log into Database
    cd /opt/rapid7/nexpose/nsc/nxpgsql/bin
    ./psql -U nxpgsql -d nexpose

You should get an output similar to the following:

root@Server1337:/opt/rapid7/nexpose/nsc/nxpgsql/pgsql/bin# ./psql -nU nxpgsql nexpose
psql (15.5)
Type “help” for help.

nexpose=#


DATABASE/SQL QUERIES: now that you are in the database, there are some queries that you must run, copy and paste these commands:

  1. SET search_path to nxsilo_default, nxadmin;

  2. SELECT * FROM users;
    use the resulting table to find the user_id associated with the account you need to delete

  3. DELETE FROM users WHERE user_id=x;
    where you replace the value for user_id as necessary.