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

Creating an EXASOL debug user on database

    XMLWordPrintable

    Details

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

      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.

      Show
      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:
      Hide
      • 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
      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: