Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 908
  • 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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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