Is the SQL-Server SYSADMIN role redundant?
| ♥ 0 |
WE see the SQL-Server rights spelled out in this other post: http://eyeontesting.com/questions/5181/we-just-recently-migrated-all-of-our-projects-to-a.html Make sure "Td_db_admin" has these Server ROLES (do not assign other roles): > * dbcreator WE know to define a SQL hi-level user "td_db_admin" or something like that, but our DBA is complaining that the additional "sysadmin" role is redundant to the other roles. Can we get away without setting that "sysadmin" role?
Marked as spam
|
Posted by |
Private answer
The SYSADMIN role in SQL-Server is REQUIRED by HP in the SQL-Server setup when the QC-Admin is trying to use Site Admin tool to do project Upgrades (i.e. upgrading projects from QC11.52 to 12.21). It is also necessary when doing the QC install and upgrading qcsiteadmin_db. Redundant or not (DBA can split hairs all day), it is REQUIRED by HP to do these tasks. Many companies decide to disable this role AFTER the upgrades are complete, then use some DBA Work-order process to have the SQL-Server DBAs enable it from time to time when doing various project maintenance in QC. Marked as spam
 Posted by pt-barnum (Questions: 4, Answers: 509) Answered on June 21, 2016 1:40 pm
|