Fix GRANT_USAGE_PRIVS script to accept all valid identifiers
Details
| Detail name | Value |
|---|---|
| Changelog Number | 11346 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 7.0.0 |
| Fix Versions | Exasol 7.0.7 |
| Resolution Date | 2021-02-12 |
Background
Version 7 introduced the new USAGE privilege that allows hiding schemas from certain users.
The script GRANT_USAGE_PRIVS helps to set USAGE privileges correctly after the migration.
Description
The script GRANT_USAGE_PRIVS fails for schemes or user names containing special character like spaces.
Workaround
There is no workaround
Fix
The script GRANT_USAGE_PRIVS allows schemas and user names for all valid identifiers.
