Create an ODBC user account and assign the odbc role

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • The ODBC driver communicates with your ServiceNow instance as a specific user. Create an ODBC user account and assign the odbc role to enable the user to communicate via ODBC.

    Avant de commencer

    Role required: admin

    Pourquoi et quand exécuter cette tâche

    The odbc role contains various additional roles, including the soap_query role required to make ODBC requests and the itil role required to access core tables such as the incident table. You can modify the odbc role to allow access to other tables as needed by adding additional child roles.

    Procédure

    1. Navigate to All > User Administration > Users.
    2. Click New.
    3. In the User ID field, enter odbc.user.
    4. Enter a Password for this user.
    5. From the form context menu, select Save.
    6. In the Roles related list, click Edit.
    7. Use the slushbucket to add the odbc role, and then click Save.
    8. Click Submit.

    Que faire ensuite

    In a separate browser session, confirm that the odbc.user is able to log in to your ServiceNow instance.