Share this page

# User Permissions for Connecting to an Oracle Database Server

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: Make sure the UPGRADE_PROJECT_BY_SUPER_USER site parameter is set to Y. Follow the instructions in DB privileges required for the optimization of table statistics gathering.

https://admhelp.microfocus.com Application Quality Management 8942
Tips to improve your search results... OpenText™ Application Quality Management Help Center OpenText™ Application Quality Management Help Center OpenText™ Application Quality Management Help 26.1 All View Local Help Center View Online Help Center Version: