Re: audit select on table by user
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Sun, 17 Feb 2013 09:52:10 +0100
Message-ID: <CALH8A90bwBdUFA2KEj4GuW0H2AJarcFJGRPp-zsj2Pn34uDXKQ_at_mail.gmail.com>
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" <JChirco_at_innout.com>:
Date: Sun, 17 Feb 2013 09:52:10 +0100
Message-ID: <CALH8A90bwBdUFA2KEj4GuW0H2AJarcFJGRPp-zsj2Pn34uDXKQ_at_mail.gmail.com>
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" <JChirco_at_innout.com>:
> 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;
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Feb 17 2013 - 09:52:10 CET