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 default is WITH NO ADMIN OPTION.
Related reference
List All System Privileges