Object owner may not be able to view all table and column privileges via drivers' metadata functions
Details
| Detail name | Value |
|---|---|
| Changelog Number | 22975 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.1.0, Exasol 8.0.0, Exasol 2025.1.0 |
| Fix Versions | Exasol 2025.1.3, Exasol 2025.2.0 |
| Resolution Date | 2025-09-17 |
Problem
When viewing the table or column privileges using Exasol drivers' metadata functions like SQLTablePrivileges, the owner of an object may not be able to view all of the object privileges. Specifically, the owner of an object can not view table and column privileges if they are neither the grantor nor the grantee of the privilege.
Affected interfaces:
- JDBC
- ODBC
- WebSocket API
Workaround
The drivers can be configured to use the “legacy metadata” mode:
JDBC: metadataSQL=1 ODBC: LEGACYCATALOG=Y
Fix
The issue has been fixed such that the owner of an object can see all of the object’s privileges.
