Filters are a great way to stop any bad query or limit the certain object or user access to the system. It's a preventative measure that can help admins to avoid any unwanted activity on the system.
By limiting object or user access, it also helps to maintain security access to the system. Tables with critical data or information can be blocked and reported from time to time.
As we have seen, the following criteria can be used to filter queries or users:
- Request source: Can block one or a set of IPs or users
- Target: Can be block based on table or database or other options
- Query characteristics: Queries with high estimations or certain join types
- Query band: Queries with certain query bands
- Utility: Application specific or ...
