In case the ARIS Risk & Compliance Manager 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 & Compliance Manager 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.
Procedure
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 DB.
ALTER USER <tenant user> GRANT CONNECT THROUGH <connection_user>
Example:
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.