• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 910
  • Last Modified:

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
0
missymadi
Asked:
missymadi
  • 2
  • 2
2 Solutions
 
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
 
ram_0218Commented:
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
 
missymadiAuthor Commented:
Thanks!

What is the sytax (SQLPLUS)  to view the existing permissions on the SYS.AUD$ table?
0
 
dbmullenCommented:
select *
from dba_tab_privs
where owner = 'SYS'
  and table_name in ( 'AUD$', 'DBA_AUDIT_TRAIL')
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now