Database Administration (MOSC)

MOSC Banner

How to audit stored procs with parameters

edited Oct 7, 2013 12:52PM in Database Administration (MOSC) 3 commentsAnswered ✓
 Hi I am auditing all stored procs. This is the list of steps:

1. ALTER system SET audit_trail=db_extended scope=spfile;

2. shutdown

3. startup

4. audit execute procedure by access;

5. select USERNAME, obj_name,ACTION_NAME,to_char(TIMESTAMP, 'MM:DD:YYYY:HH24:MI:SS') time from dba_audit_objec;

YSMAN               DBMS_APPLICATION_INFO          EXECUTE PROCEDURE    10:07:2013:16:40:37

FIRE_GAL_1           COMMON_STPS                    EXECUTE PROCEDURE    10:07:2013:16:41:02

FIRE_GAL_1           STANDARD                       EXECUTE PROCEDURE    10:07:2013:16:41:02

But this doesn't tell me anything on the parameters being passed to the stored procs. How can I get that information?
Thank you.
Debasis


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center