Flyway - create oracle schema and set permissions and password

Vote count:

0

I'm configuring an Oracle VM taken from here and want to tweak the default schema they are generating.

The Flyway is used there to create a new Oracle schema called MYSCHEMA. So the flyway user is system (default name of dba user) and the password is the system's password. E.g.

    <flyway.user>system</flyway.user>
    <flyway.password>manager</flyway.password>
    <flyway.schemas>MYSCHEMA</flyway.schemas>

Now I have two tasks:

1. I need to set a specific password for MYSCHEMA or at east to know what password has the Flyway set for it.


2. I need to set specific user permissions (GRANTs) for the MYSCHEMA user.

Both tasks should be executed by system user. Besides, there is no point to run them on every migration. Once is enough.

Can I do it inside the Flyway using callbacks or migrations?

asked 8 secs ago

Ruslan Bes

830

Flyway - create oracle schema and set permissions and password