For each Fabasoft Folio COO Service, an Oracle user has to be created. As default tablespace, use the corresponding previously created tablespace. See chapter “Tablespace Creation” for more details.
These users should have the following roles:
Additionally, the following right should be granted to the Oracle users for the Fabasoft Folio COO Services:
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO <service user>
It is also possible to grant the right DBA_PENDING_TRANSACTIONS to all Oracle users as these tables do not contain any security relevant data.
GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO PUBLIC