How do you set up auditing in Oracle 10g?

Hi,

       I need to set up auditing for two users only, admin and operator. What are the steps in setting up  auditing in Oracle 10g? How do I view the logs? How would I delete logs after so many days to prevent system lock-up?
I have read a few articles but the are a bit confusing to me.

THanks, MissyMadi
missymadiAsked:
Who is Participating?
 
ram_0218Connect With a Mentor Commented:
Only users who have been granted specific access to SYS.AUD$ can access the table to read, alter or delete from it. This is usually just the user SYS or any user who has had permissions. There are two specific roles that allow access to SYS.AUD$ for select and delete, these are DELETE_CATALOG_ROLE and SELECT_CATALOG_ROLE. These roles should not be granted to general users!
0
 
ram_0218Commented:
http://www.oracle-base.com/articles/10g/Auditing_10gR2.php

you cant escape you need to go over this :-)
0
 
missymadiAuthor Commented:
One other question regarding Auditing. Once auditing is set up, how do you set permissions on the sys.aud$ table? What is the sytax (SQLPLUS)  to view the existing permissions on this table?
0
 
missymadiAuthor Commented:
Thanks!

What is the sytax (SQLPLUS)  to view the existing permissions on the SYS.AUD$ table?
0
 
dbmullenConnect With a Mentor Commented:
select *
from dba_tab_privs
where owner = 'SYS'
  and table_name in ( 'AUD$', 'DBA_AUDIT_TRAIL')
0
All Courses

From novice to tech pro — start learning today.