SELECT *
           FROM user_auth
          WHERE  
           SYSDATE BETWEEN NVL (start_date, SYSDATE - 1)
                            AND NVL (end_date, SYSDATE + 1)

权限区间设置