DROP ANY OBJECT System Privilege

Required to drop an object owned by anyone.

The DROP ANY OBJECT system privilege allows a user to issue these statements:

  • DROP DATATYPE

  • DROP EVENT

  • DROP FUNCTION

  • DROP INDEX

  • DROP JOIN INDEX

  • DROP MATERIALIZED VIEW

  • DROP MESSAGE

  • DROP PROCEDURE

  • DROP SEQUENCE

  • DROP SPATIAL REFERENCE SYSTEM

  • DROP SPATIAL UNIT OF MEASURE

  • DROP STATISTICS

  • DROP TABLE

  • DROP TEXT CONFIGURATION

  • DROP TRIGGER

  • DROP VIEW

Grant this system privilege using the WITH ADMIN OPTION, WITH NO ADMIN OPTION, or WITH ADMIN ONLY OPTION clause. If you do not specify a clause, the WITH NO ADMIN OPTION clause is used by default.
Parent topic: Miscellaneous System Privileges
Related reference
List All System Privileges