AUDIT/MONITOR SELECTS from a TABLE - HELP

From: George/Jorge <ghharrac_at_ouray.cudenver.edu>
Date: 7 May 1998 20:13:45 GMT
Message-ID: <6it4lp$gq2$2_at_news.cudenver.edu>



Help:

In ORACLE how do I audit/monitor selects from a given table?

I need to KNOW:

        User Name
        Table Name
        Column Name(s)
        Date ?
        Number of records selected ? (if this can be done )

Ideas that I has were to turn on auditing for selects as seen in table DBA_OBJ_AUDIT_OPTS.SEL Please email: ghharrac_at_neodata.com

George H. Received on Thu May 07 1998 - 22:13:45 CEST

Original text of this message