While attempting to use H2 to verify our Flyway scripts we get an error when the following is executed:
GRANT SELECT ON HIBERNATE_SEQUENCE TO WEB_ORDER_ENTRY_FUSER; Log: SQL State : 42S02 Error Code : 42102 Message : Table "HIBERNATE_SEQUENCE" not found; SQL statement: GRANT SELECT ON HIBERNATE_SEQUENCE TO WEB_ORDER_ENTRY_FUSER [42102-197] Location : db/migration/V1.0__Initial_DB_Creation.sql (C:\Users\bu4ron6\IdeaProjects\flyway-order-service\target\classes\db\migration\V1.0__Initial_DB_Creation.sql) Line : 134 Statement : GRANT SELECT ON HIBERNATE_SEQUENCE TO WEB_ORDER_ENTRY_FUSER According to Oracle https://docs.oracle.com/database/121/ADMIN/views.htm#ADMIN11796 : > To use a sequence, your schema must contain the sequence or you must have > been granted the SELECT object privilege for another user's sequence. Is there any plan to include this in the Oracle Compatibility mode? Thanks, Cully. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
