000014363 - SQL to obtain all the users under specific administrative group

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000014363
Applies ToClearTrust Access Manager 6.0
RSA ClearTrust Server 5.5.3
Oracle Database
Sun Solaris 2.9
IssueSQL to obtain all the users under specific administrative group
Resolution


Following query gets the list of all users under a user group:

SELECT U.LAST_NAME,U.FIRST_NAME,U.NAME,U.ADMIN_GROUP_ID,AG.NAME

FROM CT_OWNER.ADMIN_GROUP AG, CT_OWNER.USERS U

WHERE (AG.NAME='AdminGroupName') ORDER BY U.NAME

Where, 'AdminGroupName' is name of your Administrative group

Legacy Article IDa44587

Attachments

    Outcomes