AUDIT/MONITOR SELECTS from a TABLE - HELP

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 have are to turn on auditing for selects as seen in table DBA_OBJ_AUDIT_OPTS.SEL george H.

Please Email: ghharrac_at_neodata.com Received on Thu May 07 1998 - 17:09:04 CDT