Skip to content

Purging database fails when user owns a schema #20

@kaklakariada

Description

@kaklakariada

Stack Trace

Caused by: com.exasol.jdbc.AccessRuleViolation: CASCADE must be specified to drop user TEST_USER (Session: 1832530210747711488)
 at com.exasol.jdbc.ExceptionFactory.createSQLException(ExceptionFactory.java:92)
 at com.exasol.jdbc.EXASQLException.getSQLExceptionIntern(EXASQLException.java:50)
 at com.exasol.jdbc.AbstractEXAStatement.execute(AbstractEXAStatement.java:462)
 at com.exasol.jdbc.EXAStatement.execute(EXAStatement.java:289)
 at com.exasol.jdbc.AbstractEXAStatement.exaExecuteLargeUpdate(AbstractEXAStatement.java:616)
 at com.exasol.jdbc.EXAStatement.executeLargeUpdate(EXAStatement.java:446)
 at com.exasol.jdbc.EXAStatement.executeUpdate(EXAStatement.java:547)
 at com.exasol.dbcleaner.ExasolDatabaseCleaner.purgeUsers(ExasolDatabaseCleaner.java:83)
 at com.exasol.dbcleaner.ExasolDatabaseCleaner.cleanDatabase(ExasolDatabaseCleaner.java:31)
 at com.exasol.containers.ExasolContainer.purgeDatabase(ExasolContainer.java:666)
 ... 13 more

Reproduction

  1. Create a DB user
  2. Create a new connection with this user and create a schema
  3. Run purge

Metadata

Metadata

Labels

bugUnwanted / harmful behavior

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions