Hi,

I've got a table that i use for loading data into the main database, as thus its cleared down after each load, and i need to reset the serial counter field.

I do that by using the alter table comand.  this all works fine with the dba user that created the table but when i try and do it with another user  it fails to do the alters due to privilages.

now when i set up the table i did a grant all on table to public, and i've even specifically granted alter to public since then but i still get an error. the only solution seems to be to grant secific users DBA. not a huge problem as none of them can get out of the application but just messy.

is there anything daft im doing or can try???

invormix is v7

Cheers

Graham