CREATE ANY INDEX System Privilege

Required to create a new index.

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.

The CREATE ANY INDEX system privilege allows a user to:

  • Create indexes on any table owned by any user
  • Issue COMMENT statement on any index owned by any user
Parent topic: Indexes System Privileges
Related reference
List All System Privileges