Special case Oracle - schema on the same instance
In case the ARIS Risk and Compliance database schema is hosted on the same Oracle instance as the schema of other ARIS products, it is possible to reuse the existing ARIS Risk and Compliance database schema by updating the privileges of the corresponding database user. However, to ensure a consistent installation it is recommended to use the ARIS external service of type DB .
Execute the following SQL statement on the corresponding Oracle instance to assign the connection privilege to the relevant database user. Schema name and user name are identical for Oracle. The connection user is the database user that is configured in the ARIS external service of type Recommended procedure for all DBMSDBRecommended procedure for all DBMS.
ALTER USER <tenant user> GRANT CONNECT THROUGH <connection_user> ALTER USER ARCM_DEFAULT_CUSTOM_SCHEMA GRANT CONNECT THROUGH ARIS10
The privileges of the database user are updated to authorize the connection by the connection user.