Ensure there are no unnecessary roles or excessive privileges

How it is checked

Audit method: Manual review

This recommendation cannot be checked automatically. A scan lists it with these instructions when you pass --include-manual.

As a superuser, retrieve all roles: list roles; Retrieve all permissions for all roles select * from system_auth.role_permissions; If there are any unnecessary roles or roles with excessive privileges this is a finding.

How it is fixed

Fix method: Guidance or infrastructure patch

Remove any unnecessary roles and/or permissions in accordance with organizational needs.