SELECT *
  FROM TBSYS_RESOURCES r
 WHERE 1 = 1
   AND r.resid IN
       (SELECT rr.resid
          FROM TBSYS_ROLE_RES rr
         WHERE rr.roleid IN (SELECT ur.roleid
                               FROM TBSYS_USERS_ROLES ur
                              WHERE ur.userid = 'nzadmin'))
    OR r.resid IN (SELECT uur.resid
                     FROM TBUSER_USERRES uur
                    WHERE uur.userid = 'nzadmin'
                      AND uur.distime > SYSDATE)
 ORDER BY SN ASC, RESID ASC

SELECT *
  FROM TBSYS_RESOURCES r
 WHERE 1 = 1
   AND r.resid IN
   (
		SELECT rr.resid
          FROM TBSYS_ROLE_RES rr
         WHERE rr.roleid IN (SELECT ur.roleid
                               FROM TBSYS_USERS_ROLES ur
                              WHERE ur.userid = 'nzadmin')
  UNION
    SELECT uur.resid
                     FROM TBUSER_USERRES uur
                    WHERE uur.userid = 'nzadmin'
                      AND uur.distime > SYSDATE
   
   )
 ORDER BY SN ASC, RESID ASC

SELECT *
  FROM TBSYS_RESOURCES r
 WHERE 1 = 1
   AND EXISTS (select resid
          from (SELECT rr.resid
                  FROM TBSYS_ROLE_RES rr
                 WHERE rr.roleid IN
                       (SELECT ur.roleid
                          FROM TBSYS_USERS_ROLES ur
                         WHERE ur.userid = 'nzadmin')
                UNION
                SELECT uur.resid
                  FROM TBUSER_USERRES uur
                 WHERE uur.userid = 'nzadmin'
                   AND uur.distime > SYSDATE
                
                ) UN
         where r.resid = UN.resid)
 ORDER BY SN ASC, RESID ASC