Database Privileges During Installation
The TIBCO JasperReports® Server installation process and the repository database user need the following privileges to install and initialize the repository database:
CREATE/DROP DATABASES CREATE/ALTER/DROP TABLES/indexes/constraints INSERT/UPDATE/DELETE DATA
Privileges for External Data Sources
The database user for an external data source (configured in the data source dialog in the server) needs to have the privileges to run SELECT queries.
We prohibit UPDATE/DELETE SQL commands in our SQL injection protection.
In some cases, additional permissions may be required to execute stored procedures, depending on your configuration and needs.