U need the query rewrite priv to create functional indexes. Grant it directly to a user and it will work!