I'm running this query:
update user_sequences set last_number = 1 where sequence_name = 'CASE_SEQ'
I get "insufficient privileges" even though I a logged in as the database owner. Nor can I "grant update on user_sequences ..." What's up with this? I'd like to be able to reset my sequence without deleting and recreating it.