I want to create and alter DB user using Liquibase. Following are the SQL queries to do so for Oracle DB.
change password:
ALTER USER ADMIN IDENTIFIED BY ${user.password};
create user:
CREATE USER appuser IDENTIFIED BY ${user.password};
I want to make the password parameterized, but changelog Property Substitution
is not available in SQL format.
I am choosing XML as the fallback option, but not able to convert above queries into Liquibase XML format. I need help in converting alter/create user queries into XML.