> select gen_id(GEN_AGENDA_NRO, 287390 - gen_id(GEN_AGENDA_NRO , 0)) from
> rdb$database

An ugly hack, I agree, but works.

>This does make you wonder if maybe RESTART WITH shouldn't fall under
>USAGE instead of the ALTER privilege (or alternatively if using gen_id
>with anything other than 0 or 1 shouldn't fall under the ALTER privilege).

I agree also: a bit strange.

Thanks.

Aldo Caruso