HP ALM SQL DATABASE USER PROFILE

  • KM01159530
  • 11-Sep-2014
  • 11-Sep-2014

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

This is document intents to guide the end user and DBA in the understanding of what are the permissions and roles of the two ALM DB users.HP ALM DATABASE USER PROFILE Database Principal i.e.: td_db_admin Creation: This user must be created by the end user prior the installation. Required Permissions: SecurityAdmin dbCreator Roles: Creates project databases Creates user td Assign permissions to the td user (Public and ddladmin) Creates td schema and makes td owner of it. This account is the owner of the database for the projects. Application User i.e.: td Creation: This user is created automatically by the installation, its roles and functionality are granted by the application using the DB Principal. Required Permissions: ddlAdmin Public Roles: This user is in charge of executing all the scripts that the application requires to its proper functionality This account is the owner of the database schema: td.