/*
 * Copyright 2004-2019 H2 Group. Multiple-Licensed under the MPL 2.0,
 * and the EPL 1.0 (http://h2database.com/html/license.html).
 * Initial Developer: H2 Group
 */
package org.h2.command.ddl;

import org.h2.api.ErrorCode;
import org.h2.command.CommandInterface;
import org.h2.engine.Database;
import org.h2.engine.Session;
import org.h2.engine.User;
import org.h2.message.DbException;

This class represents the statement DROP USER
/** * This class represents the statement * DROP USER */
public class DropUser extends DefineCommand { private boolean ifExists; private String userName; public DropUser(Session session) { super(session); } public void setIfExists(boolean b) { ifExists = b; } public void setUserName(String userName) { this.userName = userName; } @Override public int update() { session.getUser().checkAdmin(); session.commit(true); Database db = session.getDatabase(); User user = db.findUser(userName); if (user == null) { if (!ifExists) { throw DbException.get(ErrorCode.USER_NOT_FOUND_1, userName); } } else { if (user == session.getUser()) { int adminUserCount = 0; for (User u : db.getAllUsers()) { if (u.isAdmin()) { adminUserCount++; } } if (adminUserCount == 1) { throw DbException.get(ErrorCode.CANNOT_DROP_CURRENT_USER); } } user.checkOwnsNoSchemas(); db.removeDatabaseObject(session, user); } return 0; } @Override public boolean isTransactional() { return false; } @Override public int getType() { return CommandInterface.DROP_USER; } }