On 5-10-2018 21:06, Aldo Caruso aldo.caruso@...
[firebird-support] wrote:

> > 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.

I have reported it on http://tracker.firebirdsql.org/browse/CORE-5937

--
Mark Rotteveel