Information
If users with database accounts will not be using the database for some time, disabling the account will reduce the risk of attacks or inappropriate account usage.
Only actively used database accounts should be allowed to login to the database.
NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.
Solution
To lock accounts, as a superuser, run:
ALTER ROLE <account> NOLOGIN;
To unlock accounts, as a superuser, run:
ALTER ROLE <account> LOGIN;