I have a simmilar problem when creating function based indexes using the execute immediate.

I have granted 'create any index' to the user and it is possible to create conventional indexes using the execute immediate but when I use a function based index I have the 1031 error.

What priveleges need to be granted to create a function based index?

Any clues?