Hi All,

It's a mild peeve....

If I create a table where a column defaults to a sequence.nextval, and grant insert on the table to a bunch of users, It annoys me that I have to alsogrant next on the sequence to these users.

If I don't give the grant then when the users attempt an insert they get greeted with:
E_PS0D3D NEXT VALUE: you lack 'NEXT' on sequence 'test_seq' owned by 'ingres'.

I would have thought the next grant on the sequence would have been implicit.

I can't find any mention of this in the Ingres10 SQL guide under the 'sequence defaults' section of create table.

So my question is: Is this a documentation bug or a genuine problem that should be addressed by making the grant implicit?

Martin Bowes

Martin Bowes wrote:

I can't say I've motivated myself to scan the manual for any hint of
what was intended. The whole idea of mechanistically imposing spurious
uniqueness on rows makes my flesh creep. But if Ingres is going to
allow it, what the hell?--make it easy. Making it less easy doesn't
make it less troubling.

--
Roy

UK Ingres User Association Conference 2011 will be on Tuesday June 7 2011.
Put the date in your diary today.