Re: Auditing the selection SQL issuing by users in Oracle 8i

You can AUDIT SELECT ON tablename; for every object you are interested in. Or AUDIT SELECT TABLE; to audit selects on all objects. This can generate a large audit trail, so watch out! And it only tells you that a certain user did a select on a certain object. You don't see what the actual select was.

RLC wrote:
>
> I would like to know is there any possible solution to record every
> selection SQL commands issuing by users in Oracle 8i ??
Received on Tue Jul 24 2001 - 06:19:40 CDT