Upgrading to 12.5 and later: Granting the privilege to use triggers for Spotfire databases on Oracle

In Spotfire Server version 12.5, support for saving items as favorites in the library was introduced. Due to this change, the Spotfire database now needs to use triggers to store the favorites. Previously, the privilege to use triggers was not granted by the installation script for the Spotfire database. If you are upgrading a Spotfire Server using Oracle as the Spotfire database, you must manually add another grant to the spotfire database user before upgrading to version 12.5 or later (from a version before 12.5).

Granting privileges must be done by a user that can administer the database, that is, as a user with SYSDBA or DBA privileges (usually connecting as "sys as sysdba" or "system").

This cannot be done automatically during the upgrade process because the Spotfire Server installation does not remember the database administrator password.

Once connected to the database, the administrator must run the following command:

GRANT CREATE TRIGGER TO <SPOTFIRE DATABASE USER>;

This must be done before proceeding with the usual upgrade process. Previous versions will continue to run even if the spotfire database user has this new privilege, so the change in privileges can be done long before running the ordinary upgrade.

To check if a spotfire database user has the required privilege, log in to the database as the spotfire database user and run:

SELECT * FROM USER_SYS_PRIVS;

If you can see CREATE TRIGGER in the output, the spotfire database user has the privilege already.

If you are unsure what the spotfire database user name is in your system, you can find it in <previous installation root>/tomcat/webapps/spotfire/WEB-INF/bootstrap.xml, in the XML-node <username>.