W-Systems joins SugarCRM! Read Blog

Managing SQL Read-Only Users in wMobile’s SQL Manager

by Lynn Catterson on March 29, 2019

2 minute read

In GoldMine 2018.2, a new SQL user with read-only permissions will be needed for use with SQL queries, including filters created using SQL syntax.

wMobile Desktop’s SQL Manager has always only allowed SQL SELECT statements. However, for consistency, we have added the same requirement of a read-only SQL user (regardless of your GoldMine version).

wMobile Desktop SQL Manager - Database User Options

An existing SQL User can be selected, or a new one can be created, in the wMobile Manager Console.

Navigate to Desktop | SQL Queries Manager in the wMobile Explorer pane on the left.

wMobile Desktop - SQL Queries Manager

If you have already created a read-only SQL user in GoldMine or SQL, then you can enter that existing SQL user in the Manager Console. The application will check that it’s a valid user and will test the connection. Click Check user to test the credentials.

wMobile Desktop - Test SQL Read Only User Credentials

If there’s any connection issue, a warning will be displayed with the cause.

wMobile SQL Manager - Read Only User Credentials failure

The administrator can also choose to configure a new SQL user with read-only permission from the Manager Console.

In this case, the application will detect that this is a new user (by querying the database) and will create it with read-only permissions.

wMobile SQL Manager - create new SQL read-only user

In the case of a failed check, the administrator will not be able to save the settings. A failed check can occur in one of the following cases:

  1. Using an existing user and an incorrect password
  2. Using a reserved SQL keyword as user name
  3. Using a blank user name or password

wMobile SQL Manager - failed SQL user check

This SQL user will be used with the SQL Manager in wMobile Desktop and for any filters created using SQL.

wMobile - Accessing the SQL Manager

wMobile SQL Manager

Note: wMobile and above are compatible with GoldMine 2018.2. If you’re not on a version of wMobile 4.1, we’d recommend that you upgrade wMobile. Customers with current maintenance can access the wMobile 4.1 upgrade on the Demos and Downloads tab of our wMobile product web page.