This content has been marked as final. Show 2 replies
Optimize Rebuild uses a trigger to capture changes made during the optimize. So I suspect you may need CREATE TRIGGER privilege.
Please report back, and if this is the issue then I'll make sure it gets documented.
Yes indeed, granting CREATE TRIGGER solved the problem.