scrip to list user groups in Netezza

SYSTEM(ADMIN)=> \dU USER1 (d Ucaptial U)

List of Groups a User is a member
 USERNAME |    GROUPNAME
----------+------------------
 USER1 | GROUP_EXTERNALUSER
 USER1 | GROUP_READONLY
 USER1 | PUBLIC
(3 rows)