schema_version doesn't have select permission?

Question

I executed flyway:init with test/test as user/password and got the following output:

[INFO] Creating schema "MY_SCHEMA" ...
[INFO] Creating Metadata table: "MY_SCHEMA"."schema_version"
[INFO] Schema initialized with version: 1

Then I connected to oracle using MY_SCHEMA/flyway as user/password but I can't select on schema_version, I get "ORA-00942: table or view does not exist". User test cannot select on schema_version also.

How do I see what is in the schema_version table?

Thanks

Answer 1

See http://flywaydb.org/documentation/faq.html#case-sensitive

The table name must be quoted to select from it.