This discussion is archived
1 Reply Latest reply: Jan 14, 2013 5:18 AM by Tridus RSS

how to pass asp.net user to oracle trigger

SaadNayef Journeyer
Currently Being Moderated
Hi,

I'm creating a trigger (INSERT or UPDATE) on a table which is being manipulated by asp.net application. How to get web user (session user) from that trigger (web not OS_USER)?

Saad,
  • 1. Re: how to pass asp.net user to oracle trigger
    Tridus Journeyer
    Currently Being Moderated
    In a normal web application, the user connects to the web server, and the web server has a special database account to connect to the database. The trigger isn't going to have the user on the web server unless you pass it in somehow.

    This link contains some suggestions on the "somehow" part: http://stackoverflow.com/questions/1880729/how-to-send-arbitrary-parameters-to-oracle-trigger

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points