When you drop the default database for a user, the system defaults to the username space as the session database, and does not return an error or warning. The user can use the SET SESSION DATABASE statement to set the default database during the session.