...

References

Special Considerations

JDBC plugin connects to database using JDBC driver and executes SQL statements. See blog entry https://flexagon.com/make-database-changes-with-the-jdbc-plugin/

...

for examples on how to organize SQL files for deployment using partial deployment operations.

Additionally, you need to consider which user to use for execution. There are few options :

• system or admin user
  • Oracle has user called system which will be able to perform all operations. You should be careful in this situation as this user has access to do anything.
  • Object in SQL files must be schema qualified.
• schema owner
  • This is safer option than system user, but you need to grant additional permissions to schema user.
  • Objects in SQL files need not be qualified, but it is always good idea to do so, hence that would allow you to change user that executes files.
• deployment specific user, let's say FLEXDEPLOY
  • This is also safer option than system user and may offer less maintenance of permissions as one user is used for managing all schema objects. For Oracle database, you can grant DBA role to such user or you can grant specific permissions to this user as well (CREATE ANY TABLE, CREATE ANY INDEX, ALTER ANY TABLE, ALTER ANY INDEX, DROP ANY TABLE, DROP ANY INDEX etc.)
  • Objects in SQL files must be schema qualified.

Partial Deployment - Supported Object Types

...