Lab 6 · Publicly Exposed Database
A database full of sensitive rows, reachable from the internet, with an over-privileged user. Fix the network exposure in the console with DAC as your guide.
Scenario tie-in
Aurora opened to
0.0.0.0/0 on 3306/5432, a DB user granted superuser, weak varonis/password.6.1 Investigate
- Data Stores → RDS → sensitive instances; drill to Table/Columns → Compliance.
- Access tab: public exposure + over-privileged users.
6.2 Remediate (console)
- RDS → instance → security group → remove 0.0.0.0/0 on 3306/5432.
- Set Publicly accessible = No.
- Revoke superuser; disable weak
varonisaccount.
Order of operations
Close the network exposure first, then fix in-database grants.
Done when
The database is no longer internet-reachable, the DB user is right-sized, and DAC reflects it.

