Triggers in the database (changes required on upgrade when using Oracle as the
Spotfire database)
The new functionality Save items as favourites in the library uses triggers in the database,
to store the favourites. Previously, the privilege to use triggers was not granted by the
installation script for the Spotfire database.
Therefore, if you use Oracle as the Spotfire database, the spotfire database user must
get another grant before the upgrade. This must be done by a user that can administer
the database (for example, connecting as "sys as sysdba", "system", "sys / as sysdba").
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>