How to identify which ALM users are site admin users?

  • Questions
  • How to identify which ALM users are site admin users?
Question ID: 107740
2
0

Due to some ldap server issues, we need to swap our ALM back to QC authentication. I have read up on the steps for the PARAMS table under the site admin db. However after that, I have to say as long standing ldap users, I am not sure of the the site admin login user or users we would want to use after turning off ldap authentication.

How can I best find out which users are site admins?

Marked as spam
Posted by (Questions: 26, Answers: 22)
Asked on July 21, 2017 4:44 pm
4 views
Answers
2
Private answer

Hello,

As you are already familiar with your qc site admin db/schema for the PARAMS value change, you can simply run the following query against the qc site admin schema to identify the users that have the site admin role.

SELECT USERS.USER_ID, USERS.USER_NAME, ROLES.RT_ROLE_NAME
FROM USERS, USERS_ROLES, ROLES
WHERE USERS.USER_ID = USERS_ROLES.UR_USER_ID AND
ROLES.RT_ROLE_ID = USERS_ROLES.UR_ROLE_ID

Marked as spam
Posted by (Questions: 1, Answers: 116)
Answered on July 21, 2017 4:48 pm
Query is perfect, we now have a list of users then who are site admins. Thanks!
( at July 21, 2017 4:52 pm)