ALTER ANY OBJECT System Privilege

Required to alter an object owned by anyone.

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

  • ALTER TABLE

  • ALTER INDEX

  • ALTER JOIN INDEX

  • ALTER VIEW

  • ALTER MATERIALIZED VIEW

  • ALTER PROCEDURE

  • ALTER EVENT

  • ALTER SEQUENCE

  • ALTER FUNCTION

  • ALTER DATATYPE

  • ALTER MESSAGE

  • ALTER TEXT CONFIGURATION

  • ALTER TRIGGER

  • ALTER STATISTICS

  • COMMENT on different objects

  • ALTER SPATIAL REFERENCE SYSTEM

  • ALTER SPATIAL UNIT OF MEASURE

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.
Related reference
GRANT System Privilege Statement
REVOKE System Privilege Statement
List All System Privileges