Can I run as sysdba when connecting to Oracle?

Applies to: 

• Liquibase Secure (Pro)
• Liquibase Community (Open Source)

Conditions:

• Any version of Liquibase Secure (Pro) or Community
• Oracle database

Question:

Can a script be deployed to an Oracle database as a sysdba?

Answer:

Yes, Liquibase can deploy a script to an Oracle database as the sysdba.

The username is still required, but as sysdba it can be appended to the username to connect the account with the sysdba privileges.

Example:

• liquibase.properties file

  • liquibase.command.username:  as sysdba

• CLI

  • --username=" as sysdba"