CREATE ANY OBJECT System Privilege

Required to create an object owned by anyone.

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

  • COMMENT on different objects

  • CREATE DATATYPE

  • CREATE EVENT

  • CREATE FUNCTION

  • CREATE INDEX

  • CREATE JOIN INDEX

  • CREATE MATERIALIZED VIEW

  • CREATE MESSAGE

  • CREATE PROCEDURE

  • CREATE SCHEMA

  • CREATE SEQUENCE

  • CREATE SPATIAL REFERENCE SYSTEM

  • CREATE SPATIAL UNIT OF MEASURE

  • CREATE STATISTICS

  • CREATE TABLE

  • CREATE TEXT CONFIGURATION

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