Leveraging Oracle’s schema only user (18c+) and heres the LB properties file : url=jdbc:oracle:thin:least_priv_user/@0.0.0.0:1521/XEPDB1 username: liquibase_admin password: liquibase_admin123 Pre-Steps ( outside of the liquibase ) grant create session to liquibase_admin; alter user least_priv_…

ORA-01031: insufficient privileges

mohsink May 4, 2021, 4:09pm 8

The least privileged user in that jdbc string is the user used to have proxy connection to the liquibase_admin.
Heres more info on that type of accounts :

Topic		Replies	Views
Proxy user and "create any" privileges : oracle General Discussion	6	1075	December 24, 2024
generateChangeLog - required priveges? (Oracle) General Discussion	1	386	January 14, 2022
Liquibase 4.0.0 failing against HANA General Discussion	4	826	July 20, 2020
Getting ORA-00955 for CREATE TABLE LIQUIBASE.DATABASECHANGELOG General Discussion	0	493	April 10, 2023
Permissions Error with MSSQL General Discussion	2	1138	November 23, 2021

ORA-01031: insufficient privileges

Related topics