Share this page
To connect to an Oracle database server, the installing database user must have sufficient permissions to perform certain administrative tasks in Oracle. These tasks include creating the project user schema, copying data between projects, and checking that there is sufficient storage in a specific tablespace.
We recommend that your database administrator create an OpenText Application Quality Management database administrative user, for example qc_admin_db, with the specific privileges required to install.
| Create OpenText Application Quality Management database administrative user |
Your database administrator can create an OpenText Application Quality Management database administrative user using a script, see Creating DB administrative user required for ALM installation. This script creates the database administrative user with the recommended grants required on the database. Your database administrator should run the script and create this user on the staging database server. The privileges of the Oracle database user "system" changed after version 12c. If you are working with Oracle Database versions later than 12c, make sure you create an ALM database administrative user by following Creating DB administrative user required for ALM installation and grant the necessary privileges. For details on the required privileges, see Database Administrative User Privileges. |
|
Create OpenText Application Quality Management database administrative user for the optimization of table statistics gathering (Available for 17.0.1 and later) |
If you want to optimize the project upgrade process, create an OpenText Application Quality Management database administrative user with the specific privileges. This optimizes the table statistics gathering for ALM installation or upgrade. To create an database administrative user for optimized table statistic gathering:
|
