次のSELECT文は、すべてのプロキシ ユーザーのCONNECT THROUGH権限を返します。
SELECT TrustUser (FORMAT 'X(20)'), ProxyUser (FORMAT 'X(20)'), ProxyUserType FROM DBC.ConnectRulesV order by 2;
結果:
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