Query: Show the last time a policy was used to access services, and the user, role, or group that used it

Description

Determine the last time a specific policy was used to access services in AWS, along with the user, role, or group that used it. This can help in assessing the activity and access patterns related to your AWS resources, aiding in their management and security.

Query

Tables used in this query:

• aws_iam_access_advisor

SQL