What is the security difference between QC database user td and td_admin

Question ID: 109631
0
0

I’m trying to setup ALM and since it looks like it needs 2 database users td and td_admin.
What is the difference between these two and how does security need to be setup?

Marked as spam
Posted by (Questions: 72, Answers: 3)
Asked on June 18, 2020 1:57 pm
3 views
We are using SQL-Server
( at June 18, 2020 1:58 pm)
Answers
1
Private answer

For SWL-Server, the "td" user only has "public" role and is the user that does the transactions for the end users in their projects.
The "Td_admin" (or whatever name you choose) user is a higher-level user that can create/delete and maintain projects.
Please have the DBA's assign no more no less than what is in the rights requirements.

https://admhelp.microfocus.com/alm/en/15.0-15.0.1/pdfs/Install_Windows.pdf

Look in section about MS SQL Database Prerequsites on page 52.  It says:

The td_db_admin login must have the Database Creators role. You must also grant the td_db_
admin login the Security Administrators role. This allows the td_db_admin login to create and add
the td user with only those privileges required for running ALM, and to run the Maintain Project
activities, such as Verify, Repair, and Update.

Additionally, you will need "System Administrators" role when upgrading ALM/QC projects.

Marked as spam
Posted by (Questions: 3, Answers: 454)
Answered on June 18, 2020 2:08 pm