Can I run as sysdba when connecting to Oracle?

Applies to: 

• Liquibase Pro
• Liquibase Open Source (Community)

Conditions:

• Any version of Liquibase Pro or Open Source
• 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"

Related Article(s):

N/A