Restriction on update privilege
Hello,
i have one colleague who is requesting access to update one table but latter wants to be able to restrict number of rows that he can update at a time. For e.g if there are 100 rows to be updated based on the select query, he wants to do the update in batches of 10.
is this feasible pls?
Thanks