on 18-05-2020 03:03 PM
If an analysis of system dictionaries is required for trouble shooting or correction work, we usually login to the database by using a special database user, whose access privileges are limited to system dictionaries. Thus, direct access to the data tables of the database is not possible.
You can use the below SQL Statements to create the user with the necessary permissions. Once the user is created, please share the password with Exasol support in a secure way.
CREATE USER exa_debug IDENTIFIED BY "secure password"; GRANT CREATE SESSION TO exa_debug; GRANT SELECT ANY DICTIONARY TO exa_debug;
CREATE USER exa_debug IDENTIFIED BY "secure password"; GRANT CREATE SESSION TO exa_debug; GRANT SELECT ANY DICTIONARY TO exa_debug; GRANT EXPORT TO exa_debug;
Then it's time to become part of a unique family! Discover helpful tips and support other Community members with your knowledge.
Sign In