To create an index in your own schema
, one of the following conditions must be true:
The table or cluster to be indexed must be in your own schema.
You must have INDEX privilege on the table to be indexed.
You must have CREATE ANY INDEX system privilege.
To create an index in another schema
, you must have CREATE ANY INDEX system privilege. Also, the owner of the schema to contain the index must have either space quota on the tablespaces to contain the index or index partitions, or UNLIMITED TABLESPACE system privilege.
To create a domain index in your own schema
, you must also have EXECUTE privilege on the indextype. If you are creating a domain index in another user's schema, the index owner also must have EXECUTE privilege on the indextype and its underlying implementation type. Before creating a domain index, you should first define the indextype.
To create a function-based index in your own schema
on your own table, you must have the QUERY REWRITE system privilege. To create the index in another schema or on another schema's table, you must have the GLOBAL QUERY REWRITE privilege. The table owner must also have the EXECUTE object privilege on the function(s) used in the function-based index