oracle – Sequence erstellen

DROP SEQUENCE [USERNAME].seq_test_id;

CREATE SEQUENCE [USERNAME].seq_test_id 
    MINVALUE    1 
    MAXVALUE    999999999999999999999999999 
    INCREMENT   BY 1 
    START       WITH 1 
    NOCACHE 
    NOORDER 
    NOCYCLE;

GRANT SELECT, ALTER ON [USERNAME].seq_test_id TO [ROLENAME];

COMMIT;