The following select statement returns the CONNECT THROUGH privileges for all proxy users:
SELECT TrustUser (FORMAT 'X(20)'), ProxyUser (FORMAT 'X(20)'), ProxyUserType FROM DBC.ConnectRulesV order by 2;
Result:
TrustUser ProxyUser ProxyUserType -------------------- -------------------- ------------- trustuser1 APPPXYUSER1 A trustuser1 APPPXYUSER2 A trustuser1 APPPXYUSER3 A trustuser1 APPPXYUSER4 A trustuser1 PXYUSER1 P trustuser1 PXYUSER2 P trustuser1 PXYUSER3 P trustuser1 PXYUSER4 P