In this video, John Martinez shows you how to limit the number of maximum rows a user is allowed to read from the fav_colors table unless the user is in the approved role.
This policy limits the select action on this Postgres database to a maximum of 10 rows, unless the user is in the fave colors role.
I’m going to go ahead and run the query, and I can see that I’m limited to 10 rows.
Now let’s add that user to the correct role. All has been assigned.
I’ll rerun the query, and now I can see all the rows in the table.
