T.Kindermann wrote:
> Hello,
>
> i have the following problem:
>
> i must fully audit (except select-statements) all users with dba role
> (sys,system,admin (my admin user;-))
>
> so i can produce every day a list like:
>
> timestamp action username terminal ....
>
> where action is erverything from 'add datafile' to change system parameter
> and so on.
>
> does anybody have a solution or tool for this ?
>
> thanks in advance
> <please reply to the group>
>
> T.Kindermann
> Database Administrator.
> Germany
In 10g use DBMS_FGA Fine Grained Auditing
If in 8i or below it is impossible
In 9i it requires a lot of heavy lifting. As Mark said ... edition and
version are important.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jul 19 2005 - 10:03:34 CDT
