| Title | jaychouchannel Tourism_Management_System 8122bf020d91199eddfff3ee02d1632a70a9a132 Exposure of Sensitive Information Through Data Queries |
|---|
| Description | The affected component is `travel/src/main/java/com/controller/CommonController.java` at `/option/{tableName}/{columnName}`. The method is annotated with `@IgnoreAuth` and passes both path values to `CommonDao.xml`, which executes `SELECT distinct ${column} FROM ${table}`. No table or column allowlist is applied. An unauthenticated requester can retrieve values from sensitive columns, such as `GET /option/users/password`, which returned the stored administrator password in local testing. The issue exposes credential material and arbitrary low-cardinality database fields without authentication.
|
|---|
| Source | ⚠️ https://github.com/jaychouchannel/Tourism_Management_System/issues/8 |
|---|
| User | MskLov (UID 100118) |
|---|
| Submission | 07/25/2026 19:56 (1 month ago) |
|---|
| Moderation | 09/06/2026 16:20 (1 month later) |
|---|
| Status | Accepted |
|---|
| VulDB entry | 399444 [jaychouchannel Tourism-Management-System up to 8122bf020d91199eddfff3ee02d1632a70a9a132 CommonController.java getOption tableName/columnName information disclosure] |
|---|
| Points | 20 |
|---|