On 5-10-2018 21:06, Aldo Caruso aldo.car...@argencasas.com [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