Admin rights issue

[pr1]

Hello,

In a Spring Boot project, I have defined an H2 Scope.

My schema-h2.sql script contains the following code:

CREATE SCHEMA IF NOT EXISTS ABC_SCHEMA AUTHORIZATION xyz;


SET SCHEMA = ABC_SCHEMA;

Unfortunately, when I "install" my Java project, I get the following error message:

Admin rights are required for this operation; SQL statement:
CREATE SCHEMA IF NOT EXISTS ABC_SCHEMA AUTHORIZATION xyz [90040-199]

Does anyone know how make the schema-h2.sql script run in admin mode?

Many thanks.

Best regards,

pr1

[Evgenij Ryazanov]

Hello.

When you created this database a user with ADMIN rights were created using the user name and password that were specified to create a first connection. You need to use its user name and password to connect to the database.

After it you can either execute this script under that account or give ADMIN privileges to your current user using ALTER USER userName ADMIN TRUE

https://h2database.com/html/commands.html#alter_user_admin

If you lost the credentials of your initial ADMIN user you can't do anything from the SQL. You need to use the recovery tool.

https://h2database.com/html/advanced.html#using_recover_tool

[pr1]

Hi Evgenij.

I've added an ALTER USER statement to my script, and it now works fine.

Many thanks.

Cheers,

pr1

CREATE USER IF NOT EXISTS us1 PASSWORD 'us1';

ALTER USER us1 ADMIN TRUE;

CREATE SCHEMA IF NOT EXISTS MY_SCHEMA AUTHORIZATION us1;

SET SCHEMA = MY_SCHEMA;

CREATE TABLE table1 (

...