Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-71

Creating an EXASOL debug user on database

    Details

    • Type: Explanation
    • Status: Published
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: EXASolution
    • Labels:
      None
    • Solution:
      Hide

      Problem

      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.

      Solution

      • Exasol versions < 6.1:
        CREATE USER exa_debug IDENTIFIED BY "secure password";
        GRANT CREATE SESSION TO exa_debug;
        GRANT SELECT ANY DICTIONARY TO exa_debug;
        
      • Exasol versions >= 6.1:
        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;
        
      Show
      Problem 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. Solution Exasol versions < 6.1: CREATE USER exa_debug IDENTIFIED BY "secure password"; GRANT CREATE SESSION TO exa_debug; GRANT SELECT ANY DICTIONARY TO exa_debug; Exasol versions >= 6.1: 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;
    • Category 1:
      Database Administration

      Attachments

        Activity

          People

          • Assignee:
            CaptainEXA Captain EXASOL
            Reporter:
            CaptainEXA Captain EXASOL
          • Votes:
            1 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated: