From your previous post I assume you are auditing Oracle 9.2. Did you use the Lookup option to pickup the application name or you entered it manually? In the latest case what did you enter? : We have a couple of user id that have dba authority : that run in a nightly encapsulated process. : Our Sarbox buddies don't care for that needless to say, but : they are really only interested in seeing if the user id : is used outside of that application. : So, I setup the audit to include these power users and to : exclude this certain application. To test this, I logged : into SqlTalk and updated a record, committed, updated to the : previous value and commited. Result was no audit trail recorded. : If I select to use all apps, then it does get captured. (and : SqlTalk was not the excluded app) : Am I doing something incorrect? It seems fairly straightforward. I : did notice that if the trigger can't find the app (ie, the : program name is returned as null in the query) then it retuns. : Thanks in advance for your assistance. : Randy
|