Create an ODBC user account and assign the odbc role

  • 릴리스 버전: Australia
  • 업데이트 날짜 2026년 03월 12일
  • 소요 시간: 1분

    • 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.

    시작하기 전에

    Role required: admin

    이 태스크 정보

    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.

    프로시저

    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.

    다음에 수행할 작업

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