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 default is WITH NO ADMIN OPTION.

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
Related reference
List All System Privileges