Exam 1z0-071 topic 1 question 272 discussion

o create an index on a table in another schema in your own schema, you must either own the table or have been granted the INDEX object privilege on that table, or possess the CREATE ANY INDEX system privilege​ docs.oracle.com . In our scenario the table isn’t owned by the user, so the user needs either the object privilege (GRANT INDEX ON table_name TO user) or the CREATE ANY INDEX privilege. Having either of those will satisfy the privilege requirement to create the index. (If the user already has CREATE ANY INDEX, that covers it; if not, the table’s owner can grant the INDEX privilege on that specific table.)