org.hibernate.tool.schema.extract.spi.SchemaExtractionException: More than one table found in namespace

 

Caused by: org.hibernate.tool.schema.extract.spi.SchemaExtractionException: More than one table found in namespace (, ) : table_abc

...

...

https://stackoverflow.com/a/40243342

Check your database schema/s and your database user privileges;

Hibernate update mechanism may fail with this exception if there is a another database schema/user with the same table name, and the db user has the sufficient privileges to view this table.

So in your case, the table 'YYYYYYY' may be found in more than one database user/schema, and your db user has 'DBA' privileges.

To solve this you can either find and delete the ambiguous table or remove the user's redundant privileges.

Choose to go for: remove the user's redundant privileges.

Reset and change user privileges for user [job_service] using root.

REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'user_abc';

GRANT ALL PRIVILEGES ON targeted_table.* TO 'user_abc'@'%' WITH GRANT OPTION;

FLUSH PRIVILEGES;