Traversing Access Paths From a Specific AWS RDS Instance

Working backward from a resource to see who can access it based on which policies

IAM Pulse

by IAM Pulse

Jun 10, 2022

0

Do you work with infrastructure code and find yourself asking, “what would happen if we made this change?” Deriving meaning from looking at code alone is challenging – let’s visualize it!

Introduction

A common way to frame IAM is with the statement, who can do what under which conditions. As such, it’s natural to think of IAM as working forward – Principals performing Actions against Resources. This isn’t always the case in practice – sometimes you have to work backward from a Resource to answer the question, who can access this? Phrasing is only a frame of reference, what’s important when deriving permission sets is parsing all applicable policies, which can include:

  • Inline Role policies
  • Inline User policies
  • Resource policies
  • Permission boundaries
  • And more…

To demonstrate a common permissions scenario, let’s introduce A Team Called Quest (ATCQ) – where the cloud is their native tongue. Even when their environment was small, it was a non-trivial problem that consumed significant resources and time. As the company grew, so did its policy sprawl, making it increasingly difficult to wrangle. Exercises in exploration quickly turned into mysteries… and not the fun kind.

Let’s check-in with the team at ATCQ to ask “what if?

What's The Scenario?

Our previous Database Engineer at ATCQ, Manuel, only used local database authentication for RDS access. Our new engineer João is intent on modernizing access controls and wants to implement stronger IAM authentication for RDS. He asked our Operations team what he thought was a simple question – “Which IAM Groups or Services have access to this RDS instance? More specifically, who can connect to it using the IAM action ‘rds-db:connect’?

The environment is fully managed via Infrastructure as Code, so the Operations team can inspect the Terraform to answer the question.

Here’s the codebase for inspection.

How can we tell who has access to this RDS instance?

The Old Way

AWS doesn’t provide a simple way to look at all access vectors from the perspective of a single resource, so we would have to enumerate through all of the applicable policies – this takes a lot of time!

We could grab all of the policies in a single AWS account with the following command, but even for a simple account, it’s far too much information to parse through.

sh

% aws iam get-account-authorization-details | wc -l
  42917

We could grep this output for RDS, but what exactly would we grep for? “rds:”? What about *:* permissions? Because of how IAM uses wildcard expansion it’s hard to decompose an exact matching for this permissions set.

The New Way - Visualizing IAM

Using a visualization technique that gives us a complete view of an account, we can work backward from RDS, finding out the Principals who can perform which Actions because of what Policies.

Here’s a view of the account filtered by the RDS service. Of our 3 regional teams, APAC and LATAM have full RDS access through two different policies.

However, João’s question is even more specific - what principals in the environment can execute a specific action, ‘rds-db:connect’. Let’s filter the view to show only that Action.

In a few steps, João can quickly identify which IAM Role can access the database and connect to it with IAM, something that could take hours with native tooling.

Conclusion

As you’ve seen, any of the legacy methods for discovering which principals have the ability to execute an action on a resource is a difficult problem due to the way IAM is designed. Even with Terraform code, it still requires us to find every single principal, find all the IAM policies attached to them, and parse them.

Our method of visualizing an entire AWS environment is much easier - we can pivot the access vectors based on a single resource to see who has access. We can even filter for a particular IAM Action and see which principals can access it, regardless of how IAM constructs the allowed path.

At IAM Pulse we’re taking a fresh, visual approach to modeling IAM to spark that “aha” moment when asking yourself “what if?”. If you run across a scenario that you think would be interesting to visualize, please let us know by commenting here or sending us an email at team@iampulse.com.

    img

    Related Scenarios

    SCENARIO

    Handling Implicit Differences in AWS IAM Defaults

    What happens when you encounter implicit differences in AWS services?

    Jun 10, 2022 by IAM Pulse

    0
    SCENARIO

    Changing AWS S3 Shadow Permissions

    Removing S3:* in favor of explicit actions to better control access to sensitive...

    Jun 10, 2022 by IAM Pulse

    0
    img

    Join the beta waitlist

    Enter your email to get notified when our product becomes available to try.

    Sign Up for the community

    Create your member profile to get involved with our content, programs, and events.