2 Replies Latest reply: May 4, 2013 12:21 AM by damorgan RSS

    Logon Trigger

    1007036
      I need to make a trigger which prevents a user from logging in on a sunday but have no clue on how to do so, as i dont know how to build triggers on database...
      Can anyone help me out????
        • 1. Re: Logon Trigger
          Tubby
          1004033 wrote:
          I need to make a trigger which prevents a user from logging in on a sunday but have no clue on how to do so, as i dont know how to build triggers on database...
          Can anyone help me out????
          One of the first results when I use google.

          http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1844531724208

          Cheers,
          • 2. Re: Logon Trigger
            damorgan
            http://www.morganslibrary.org/reference/system_trigger.html

            If the date is a Sunday ... you can use TO_CHAR ... raise an error.