If you want to watch the indexes one account can access, types of the indexes, and columns of which table the indexes are based on, the following SQL could help:

SELECT a.index_name,a.index_type,a.table_name,b.column_name from USER_INDEXES a,USER_IND_COLUMNS b WHERE a.index_name = b.index_name;