Problem Note 35705: Access to the JDBC Explorer in SAS® Digital Marketing Studio is not controlled
 |  |  |  |  |
The JDBC Explorer Console within SAS Digital Marketing Studio is currently available to all level-4 administrators by default. This is considered a security risk. Access to the JDBC Explorer in SAS Digital Marketing Studio should be controllable. Only certain level-4 administrators should be permitted access to the JDBC Explorer.
Select the Hot Fix tab in this note to access the hot fix for this issue.
The hot fix provides a means to control access to the JDBC Explorer. To disable access, an administrator should add the following line to the file, !SDMROOT\config\server.properties:
DisableJDBCExplorer=true
This property can only be set by directly editing this file; the option is not displayed in the Advanced Server Properties tab in the Server Configuration dialog box. Once set to true, the JDBC explorer button remains visible in the UI, but if selected, returns the following error and prevents access:
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Digital Marketing | Microsoft Windows 2000 Advanced Server | 5.1 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 5.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Server | 5.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows 2000 Professional | 5.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows NT Workstation | 5.1 | 9.1 TS1M3 SP4 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Windows Vista | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled HP-UX | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| HP-UX IPF | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Linux | 5.1 | 5.3 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||