The following SELECT statement displays information about all users owned or created by the current user, Jones.
SELECT UserName,CreatorName,PermSpace,SpoolSpace FROM DBC.UsersV;
Result:
UserName CreatorName PermSpace SpoolSpace -------- ----------- --------- ---------- Jones sysadmin 1,000,000 1,000,000 Peterson Jones 100,000 1,000,000 Moffit Jones 100,000 1,000,000 Chin Jones 100,000 1,000,000 Greene Jones 100,000 1,000,000