Use admin user for database setup and app user for runnning the application in Springboot Tests with @Sql
I’m trying to automate an integration test on my backend application against an oracle database. I can bring up a separate docker container with the schema and i can connect to it using the schema owner no problem. My application has a special user (user_app, different from the schema owner) to connect to the database, with limited grants. The profile for normal opertation and deployment looks like this: