[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


Oracle Financials Auditing

Posted on 2004-10-27
Medium Priority
Last Modified: 2013-12-01
I am auditing Oracle Financials (11.0.3 version)  via Oracle aiditing rather than via the the Financials.
I need to know the os username of the person who is running the app rather than 'applprd' or some generic aplication id.
I set up auditing ' by session' but I get the generic userid and the action_name is 'session rec' when I select from dba_audit_trail.
I would like to see the osusername and the action , such as  'select, insert, update,delete'.

This is one row of the output:

27-oct-04 10:24:19 applprd    APPS       APPLSYS    FND_USER                             SESSION REC

selecting  from the aud$ table is not giving the desired result either.
I also tried audit .. by access but the action_name comes out as 'session_rec' as well.

Thanks for the help.

If this is easier to do via the APP then I nedd to know how.

Question by:praimsankar
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 12480444
Hi praimsankar,
You could use the OSUSER from V$SESSION dynamic view.  You would need to have some way of identifying which session you are interested in.
LVL 10

Accepted Solution

peterside7 earned 1000 total points
ID: 12717078
The calls in the Financials are channel through a generic schema.
You will NOT be able to use the Oracle Auditing for your need.
You should setup a trigger (on major tables only) to insert rows in a table instead.
LVL 10

Expert Comment

ID: 12717195
Here's the columns in the aud$ view
The only one you could use are the USERID and USERHOST, and since you tried to audit
by access and session, nothing more can be done with the Oracle auditing.

Maybe the TERMINAL field could give you info on where the command is coming from.
Same info as in sqlplus:
select userenv('TERMINAL') from dual;
Gives you the name of your pc in client/server.

SQL> desc sys.aud$;
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------------
 SESSIONID                                 NOT NULL NUMBER
 ENTRYID                                   NOT NULL NUMBER
 STATEMENT                                 NOT NULL NUMBER
 TIMESTAMP#                                NOT NULL DATE
 USERID                                             VARCHAR2(30)
 USERHOST                                           VARCHAR2(128)
 TERMINAL                                           VARCHAR2(255)
 ACTION#                                   NOT NULL NUMBER
 RETURNCODE                                NOT NULL NUMBER
 OBJ$CREATOR                                        VARCHAR2(30)
 OBJ$NAME                                           VARCHAR2(128)
 AUTH$PRIVILEGES                                    VARCHAR2(16)
 AUTH$GRANTEE                                       VARCHAR2(30)
 NEW$OWNER                                          VARCHAR2(30)
 NEW$NAME                                           VARCHAR2(128)
 SES$ACTIONS                                        VARCHAR2(19)
 SES$TID                                            NUMBER
 LOGOFF$LREAD                                       NUMBER
 LOGOFF$PREAD                                       NUMBER
 LOGOFF$LWRITE                                      NUMBER
 LOGOFF$DEAD                                        NUMBER
 LOGOFF$TIME                                        DATE
 COMMENT$TEXT                                       VARCHAR2(4000)
 CLIENTID                                           VARCHAR2(64)
 SPARE1                                             VARCHAR2(255)
 SPARE2                                             NUMBER
 OBJ$LABEL                                          RAW(255)
 SES$LABEL                                          RAW(255)
 PRIV$USED                                          NUMBER
 SESSIONCPU                                         NUMBER

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Verbose logging is used to diagnose garbage collector problems. By default, -verbose:gc output is written to either native_stderr.log or native_stdout.log.   It is also possible to redirect the logs to a user-specified file. This article will de…
This exercise is about for the following scenario: Dmgr and One node with 2 application server. Each application server contains it owns application. Application server name as follows server1 contains app1 server2 contains app1 Prereq…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question