The following SELECT statement returns the accounts the user controls:
SELECT * FROM DBC.AccountInfoV;
Result:
Name AccountName UserOrProfile ------------- ------------- -------------- DBC DBC User CONSOLE DBC User SystemFe SystemFe User Crashdumps Crashdumps User TDPUSER $H User SysAdmin SysAdmin User Sys_Calendar Sys_Calendar User V2R5IN DBC User