Network and Multi-user Installation

SQLEditor should work in a network environment. It does require access to ~/Library/Application Support and the ability to set user preferences.


It has been reported that parts of these instructions relating to installing a plist file in the system Library will not work on newer MacOS releases.

It is currently advised to set the preference keys via the defaults command, specifying the relevant option for a machine wide setting.


SQLEditor registrations are stored per-user unless you manually create a shared preference file storing them machine-wide.

On 10.6 and earlier, SQLEditor used to set preferences for all users on a machine, however Apple prevents this on 10.7 without admin privileges and we didn't think it was correct to add security critical code that runs with elevated privileges just to set the registration details.

Registration keys that SQLEditor uses

SQLEditor uses the file com.malcolmhardie.sqleditor.cococa.plist to store preferences including registration details. There are three keys that are used for registration

  • SQL2RegistrationStatus - this should be value REGISTERED
  • SQL2Username - the username as specified when you bought SQLEditor
  • SQL2Code - the serial as sent to you.

If you register a copy of SQLEditor and open the com.malcolmhardie.sqleditor.cococa.plist file in your own user ~/Library/Preferences directory, you should see all three keys.

Single Machine - Multiple Users

The aim here is to create a copy of the SQLEditor preferences file containing only the key value pairs for registration and then save this new file in the system wide Library directory

1. Create a plist file at /Library/Preferences/com.malcolmhardie.sqleditor.cococa.plist
(The preferences directory of the Library directory at the root of your hard disk).

2. For each key (mode, Username, SerialCode) copy the key and value into the new plist file.

It should look something like this. Replacing these example values with your own.

Machine Wide Preferences file

(The username and license code shown here are for illustration only and should be replaced with your own license details)

It is not recommended to copy any other keys, but this can be done if required.

Managed Preferences

The above instructions should also work for managed preferences, however we don't have knowledge of anyone actually doing this in a deployed environment.

If you implement this, we'd be interested to hear of your experiences.

Feel free to send us an email at

Support Updates

Contact Us

To contact us with a support issue please email: