Subject RE: [firebird-support] Sweep and non SYSDBA User
Author Leyne, Sean

> A sweep can only be made by SYSDBA or the owner of the DB. Assume I
> a user USER1, who is not the DB owner. USER1 starts a transaction and
> the gap between OAT and OIT becomes greater than the sweep interval.
> USER1 now allowed to run the automatic background sweep or not?

First, Sweep <> Garbage Collection

Second, a sweep will be automatically be initiated, by any user, if the
sweep internal condition has been met. If you don't want users to
initiate a sweep, set the interval to 0.

Running/initiating a sweep via GFix is considered a db maintenance task,
hence the specific access requirements.