View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006553 | SymmetricDS Pro | Improvement | public | 2024-08-09 20:48 | 2024-08-09 21:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.8 | Fixed in Version | 3.15.8 | ||
| Summary | 0006553: SQL Explorer privileges for read-only queries | ||||
| Description | Add privileges to SQL Explorer for read or read/write access to: - SQL Editor - DB Import - DB Export - DB Fill - DB Compare The READ role should be able to run "select" statements only, export data, and compare data, but not run other SQL, import data, fill data, or repair data. Log the user executing any queries or other SQL. Log when a user is blocked from running SQL. | ||||
| Tags | security | ||||
|
SymmetricDS: 3.15 02e157fc 2024-08-09 20:50:01 Details Diff |
0006553: SQL Explorer privileges for read-only queries |
Affected Issues 0006553 |
|
| add - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/AbortedQueryException.java | Diff File | ||
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/DefaultButtonBar.java | Diff File | ||
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/Settings.java | Diff File | ||
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/SqlExplorer.java | Diff File | ||
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/SqlRunner.java | Diff File | ||
| mod - symmetric-sqlexplorer/src/main/java/org/jumpmind/vaadin/ui/sqlexplorer/TabularResultLayout.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2024-08-09 20:48 | elong | New Issue | |
| 2024-08-09 20:48 | elong | Status | new => assigned |
| 2024-08-09 20:48 | elong | Assigned To | => elong |
| 2024-08-09 20:48 | elong | Tag Attached: security | |
| 2024-08-09 20:51 | elong | Status | assigned => resolved |
| 2024-08-09 20:51 | elong | Resolution | open => fixed |
| 2024-08-09 20:51 | elong | Fixed in Version | => 3.15.8 |
| 2024-08-09 21:00 | admin | Changeset attached | => SymmetricDS 3.15 02e157fc |
| 2024-08-16 17:45 | admin | Status | resolved => closed |