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

Resources / 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.

Banner title

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur varius augue a nibh feugiat.

Banner image
Categories
Default Tag Default Tag Default Tag Default Tag Default Tag Default Tag Default Tag Default Tag Default Tag Default Tag Default Tag