Problem:


When attempting to access Spire Company Setup, a message is displayed indicating "Insufficient rights".  If an attempt is made to fix the issue via PgAdmin the error message "...duplicate key value violates unique constraint "system_settings_pkey"..." is displayed.


Solution:


PgAdmin can be used to resolve the "Insufficient rights" issue using the following statement:



UPDATE system_settings SET txt_data = 'Y' WHERE key = 'spire.user.allow_edit' AND "user" = 'C';