Currently, the deployment guide just describes from a high level perspective to assign basic read/write access to data and rules tables with rules resolution. But, doesn’t specify what are data tables and rule tables that would have rules resolution.
Would like to collect information on exactly what are data tables, and rule tables that would have rules resolution. And exactly what PEGA means by basic read/write access in terms of Oracle privileges that is required to be assigned to data and rule tables with rules resolution.
The user defined in your jdbc/PegaRULES datasource needs to be able to select, insert, update, delete, execute anything in the rules and data schemas. The user also needs select_catalog_role. As part of the installation/upgrade all of the privileges needed on the rules schema have been granted to the data schema user so you could run the system as the data schema user. If you want to allow schema changes to happen automatically (during import, optimizing property for reporting, etc.) you would need to define a jdbc/AdminPegaRULES datasource with additional privileges to create, alter, etc. any table, view, etc.