[Oracle] CREATE USER ORA-01031: insufficient privileges

[regseb]

Hello,

I'm trying to mount an Oracle database, but I don't have the permissions to create a user.

With this files:

• application.yml

  spring:
    datasource:
      url: jdbc:tc:oracle:21-slim-faststart:///databasename?TC_INITSCRIPT=file:src/test/resources/schema.sql
      driverClassName: org.testcontainers.jdbc.ContainerDatabaseDriver

• src/test/resources/schema.sql

  CREATE USER FOO IDENTIFIED BY FOO;

I get this error:

2023-06-29 15:39:12.661 DEBUG 48334 --- [    Test worker] .a.t.a.c.a.c.CompteRestApiControllerTest : Running with Spring Boot v2.7.8, Spring v5.3.25
2023-06-29 15:39:12.661  INFO 48334 --- [    Test worker] .a.t.a.c.a.c.CompteRestApiControllerTest : The following 1 profile is active: "test"
2023-06-29 15:39:31.967 ERROR 48334 --- [    Test worker] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.

org.testcontainers.ext.ScriptUtils$UncategorizedScriptException: Failed to execute database script from resource [CREATE USER FOO IDENTIFIED BY FOO;
]
...
Caused by: org.testcontainers.ext.ScriptUtils$ScriptStatementFailedException: Script execution failed (file:src/test/resources/schema.sql:1): CREATE USER FOO IDENTIFIED BY FOO
	at org.testcontainers.jdbc.JdbcDatabaseDelegate.execute(JdbcDatabaseDelegate.java:59) ~[jdbc-1.18.3.jar:na]
	at org.testcontainers.delegate.AbstractDatabaseDelegate.execute(AbstractDatabaseDelegate.java:38) ~[database-commons-1.18.3.jar:na]
	at org.testcontainers.ext.ScriptUtils.executeDatabaseScript(ScriptUtils.java:438) ~[database-commons-1.18.3.jar:na]
	... 127 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: ORA-01031: privilèges insuffisants

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1011) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2163) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2118) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:328) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	at org.testcontainers.jdbc.JdbcDatabaseDelegate.execute(JdbcDatabaseDelegate.java:46) ~[jdbc-1.18.3.jar:na]
	... 129 common frames omitted
Caused by: oracle.jdbc.OracleDatabaseException: ORA-01031: privilèges insuffisants

	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637) ~[ojdbc8-21.5.0.0.jar:21.5.0.0.0]
	... 142 common frames omitted

How can I execute my SQL script with user creation permissions?