Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking Administration
  3. Authentication
  4. Security
  5. Connection Management
  6. JDBC Client Configuration
  7. ODBC Client Configuration
  8. Configuration for MicroStrategy
  9. Access Control
  10. Logs
  11. High Availability
  12. Server Control
  13. Performance Tuning
  14. Troubleshooting
  15. Appendix A: Database Keywords

Administrator Guide

Administrator Guide

Step 2. Grant File Permissions

Step 2. Grant File Permissions

Before you set up the Driver Manager proxies, you must identify the Driver Manager proxy that you want to install on the target application architecture and the ODBC 32-bit or 64-bit usage. Then you must change the owner of the Windows Driver Manager files and grant the required permissions.
  1. Find the ODBC Driver Manager DLL file on the Windows machine based on the architecture of the target application. Complete the remaining steps for each of the required Driver Manager files on the machine.
    1. On a 64-bit Windows machine, you can find the following Windows Driver Manager files:
      • 64-bit Driver Manager:
        <Windows installation>\System32\odbc32.dll
      • 32-bit Driver Manager:
        <Windows installation>\SysWOW64\odbc32.dll
    2. On a 32-bit Windows machine, you can find the following Windows Driver Manager file:
      • 32-bit Driver Manager:
        <Windows installation>\System32\odbc32.dll
  2. In Windows Explorer, right-click the file and click
    Properties
    .
    The
    odbc32.dll Properties
    window opens. The following image shows the window:
    The General tab of the odbc32.dll Properties window is selected.
  3. Select the
    Security
    tab and click
    Advanced
    .
    The
    Advanced Security Settings for odbc32.dll
    window opens.
  4. Select the
    Owner
    tab and click
    Edit
    .
  5. In the window that opens, select the current user and click
    Apply
    .
  6. Click
    OK
    to close the window.
  7. Click
    OK
    to close the
    Advanced Security Settings for odbc32.dll
    window.
  8. In the
    odbc32.dll Properties
    window, click
    OK
    to close the window. You must close the properties window before you make additional changes to the file.
  9. Reopen the
    odbc32.dll Properties
    window. Right-click the file and click
    Properties
    .
  10. Select the
    Security
    tab and click
    Advanced
    .
    The
    Advanced Security Settings for odbc32.dll
    window opens.
  11. In the
    Permissions
    tab, select the Administrators group and click
    Change Permissions
    .
    The following image shows the
    Permissions
    tab:
    In the Permission Entries box, the Administrators line is selected.
  12. In the window that opens, select the Administrators group again and click
    Edit
    .
    The
    Permission Entry for odbc32.dll
    window opens.
  13. Click the
    Allow
    box in the
    Full control
    row to grant full permissions to the user.
    The following image shows the window with the
    Full control
    box selected:
    The Allow box is selected for all of the rows.
  14. Click
    OK
    to close the window.
  15. Click
    OK
    to close the previous window. A dialog box asks if you want to continue. Click
    Yes
    to close the window.
  16. Click
    OK
    to close the
    Advanced Security Settings for odbc32.dll
    window.
  17. Click
    OK
    again to close the
    odbc32.dll Properties
    window.
    The permissions changes are saved.

0 COMMENTS

We’d like to hear from you!