Query: Show unused services granted to a role, including the policy that grants access and the actions granted

Description

Determine the areas in which services have been granted to a role but remain unused, including the specific policy that provides access and the actions permitted. This is particularly useful for identifying potential security risks and optimizing resource usage by revoking unnecessary permissions.

Query

Tables used in this query:

• aws_iam_access_advisor

SQL