Selecting schemas in JMP® 19 Query Builder causes JMP to become non-responsive.

[#1]

In some instances, connecting Query Builder to a database may cause JMP® to become non-responsive. This will typically be noticed at the Select Database Connection after connecting to your DSN.

JMP 19 checks for implicit SELECT table privileges, which negatively impacts JMP for customers with a lot of data tables within a database.

Workaround:

1. Close JMP and reopen it.
2. Click File > New > Script.
3. Please paste the JSL Preferences(ODBCIgnorePrivileges(1));
4. Execute the command.
5. You will now be able to select your schema and populate tables after connecting in the Select Database Connection screen.

To avoid repeating this workaround daily, create a Startup Script that sets the following preference in JSL.

Preferences(ODBCIgnorePrivileges(1));