Restricting database user permissions
The database administrator might require that you provide the specific permissions to access the Rule Execution Server or Decision Center database.
Connection to the database, as established in the data source credentials, and any subsequent requests to the database are handled through a database user. This database user is defined by the database administrator and has no relation to the standard Rule Execution Server or Decision Center roles.
The following table gives the list of permissions on operations in the Rule Execution Server database.
Database permission | Operation | |
---|---|---|
Browse and edit rulesets and RuleApps | Create the Rule Execution Server schema | |
CREATE INDEX | Not required | Required |
DROP INDEX | Not required | Required |
CREATE SEQUENCE | Not required | Required |
DROP SEQUENCE | Not required | Required |
SELECT SEQUENCE | Required | Not required |
CREATE TABLE | Not required | Required |
DROP TABLE | Not required | Required |
INSERT TABLE | Required | Not required |
SELECT TABLE | Required | Not required |
UPDATE TABLE | Required | Not required |
DELETE TABLE | Required | Not required |
CREATE TRIGGER | Not required | Required |
CREATE VIEW | Not required | Required |
DROP VIEW | Not required | Required |
The following table gives the list of permissions required on the Decision Center database.
Database permission | Operation | |||
---|---|---|---|---|
Use Decision Center | Create the database schema by using the Decision Center Enterprise console or Ant tasks | Modify the database schema by using the Decision Center Enterprise console or Ant tasks | Migrate the database schema | |
ALTER TABLE | Not required | Not required | Required | Required |
CREATE INDEX | Not required | Required | Required | Required |
CREATE ROLE | Not required | Not required | Not required | Required |
CREATE SEQUENCE | Not required | Required | Required | Required |
CREATE TABLE | Not required | Required | Required | Required |
CREATE VIEW | Not required | Required | Required | Required |
DROP INDEX | Not required | Not required | Required | Required |
DROP SEQUENCE | Not required | Not required | Required | Required |
DROP TABLE | Not required | Not required | Required | Required |
DROP VIEW | Not required | Not required | Required | Required |
INSERT TABLE | Required | Required | Required | Required |
SELECT SEQUENCE | Required | Required | Required | Required |
SELECT TABLE | Required | Required | Required | Required |
UPDATE TABLE | Required | Required | Required | Required |