drop user X casacde...
say x has an access to database Y, you have to revoke it beforedropping the user... takes ages.