Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    1

    Unanswered: About logon trigger

    I want to authenticate that user can access a particular schema by a particular application which is running on JBOSS application server. how can i identify that which application is accessing schema?
    Plz suggest as soon as possible........

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Please see the following link. Check out module.

    SYS_CONTEXT
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Oct 2002
    Location
    Cape Town, South Africa
    Posts
    253
    1 SELECT PROGRAM FROM V$SESSION
    2* WHERE AUDSID = SYS_CONTEXT('USERENV', 'SESSIONID')
    3 /

    PROGRAM
    -------------------------------------------------------
    sqlplus.exe

    1 row selected.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •