I am more of a Vertica database user than admin, so I'm not even sure if what I'm asking is absurd, but here goes nothing...
- Could I, as an admin, put default restrictions on the number of rows that can be exported per export query? I would like to make sure most users can only export a certain number of rows at a time, and that they cannot change the setting which prevents a massive export. I realize there are probably be ways around this restriction
- Would there also be a way to catch a user pulling small amounts of data incrementally from the same data set?
An answer to question (1) would suffice, but I would appreciate any input on question (2), as well.