Who Can Drop a Sequence?
The DROP SEQUENCE
(DROP GENERATOR
) statement can be executed by:
-
The owner of the sequence
-
Users with the
DROP ANY SEQUENCE
(DROP ANY GENERATOR
) privilege
The DROP SEQUENCE
(DROP GENERATOR
) statement can be executed by:
The owner of the sequence
Users with the DROP ANY SEQUENCE
(DROP ANY GENERATOR
) privilege
DROP SEQUENCE
EMP_NO_GEN
series:DROP SEQUENCE EMP_NO_GEN;