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

Video

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.

John Martinez, Technical Evangelist

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.