Welcome to ILOG JRules > Installing the JRules Modules > Installing JRules Modules on Tomcat 6.0 > Installing Rule Execution Server on Tomcat 6.0 > Rule Execution Server Database User Permissions

Rule Execution Server Database User Permissions

 PREVIOUS NEXT

The data source that contains the Rule Execution Server data is always mapped to a database user.

The following table highlights the database permissions you must enforce for the database user with attention given to the type of operation you wish them to perform:

Table 7 Rule Execution Server Database User Permissions

 
Operation 
Database Permission 
Browse and edit rulesets/ruleApps (bres_admin) 
Create the RES schema manually 
CREATE ANY INDEX 

 
Yes 
DROP ANY INDEX 

 
Yes 
CREATE ANY ROLE 

 

 
CREATE ANY SEQUENCE 

 
Yes 
DROP ANY SEQUENCE 

 
Yes 
SELECT ANY SEQUENCE 
Yes 

 
ALTER ANY TABLE 

 

 
CREATE ANY TABLE 

 
Yes 
DROP ANY TABLE 

 
Yes 
INSERT ANY TABLE 
Yes 

 
SELECT ANY TABLE 
Yes 

 
UPDATE ANY TABLE 
Yes 

 
CREATE ANY VIEW 

 
Yes 
DROP ANY VIEW 

 
Yes 

Note
The database privilege types differ across the supported databases. The operation of defining these privileges should be performed by a database administrator.

Copyright © 1987-2008 ILOG S.A. All rights reserved. Legal terms. Documentation homepage. PREVIOUS NEXT