Re: audit select on table by user

From: Martin Berger <>
Date: Sun, 17 Feb 2013 09:52:10 +0100
Message-ID: <>

From my experience you can just add audit options, but don't apply any filter.
From a security definition I understand this behaviour: if data in a table is important, it's important regardless the user. Everything else would make no sense.
From other (ops) reasons I often use auditing I understand your demand.   Martin
 Am 15.02.2013 22:50 schrieb "Jeff Chirco" <>:

> Is it possible to a specific users access to a specific table? After
> looking through the documentation I don't see a way. I could do it with
> Fine Grain Auditing by having it call a procedure to log to my own table
> but I want the SQL statement that was run included bind variables.
> Basically I was hoping I could do something like the following
> Audit select on scott.emp by user1;
> --

Received on Sun Feb 17 2013 - 09:52:10 CET

Original text of this message