<img src="https://ws.zoominfo.com/pixel/6169bf9791429100154fc0a2" width="1" height="1" style="display: none;">

videos

Restrict SELECT Actions Based on Geo Privacy Requirements, Returning 10 Rows

In this video, John Martinez shows how the policy helps protect from DOS attacks (SQL floods), by limiting both the maximum number of rows returned in the specified table, as well as restricting access from the US geolocation.

Transcript

This policy permits the select action on a production database. When reading from the cardholder's table and the location is in the United States, it also returns a maximum of 10 rows.

Let's go connect to the database and select that cardholder's table.

A maximum of 10 rows has been returned.

Next Steps

StrongDM unifies access management across databases, servers, clusters, and more—for IT, security, and DevOps teams.

Banner image
Categories