Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Fine-Grained Auditing OCP Question

Fine-Grained Auditing OCP Question

From: Buck Turgidson <jc_va_at_hotmail.com>
Date: Tue, 11 Mar 2003 01:44:21 GMT
Message-ID: <Vbbba.147974$P1.8963177@news1.east.cox.net>


I am wrestling with the following question (which I got wrong), and would like some opinions. I chose a and d, but apparently the correct answer is d and e. How could you differentiate access between internal and external users?

In which 2 situations would Fine-Grained Auditing be beneficial:

You need to track all accesses of the EMPLOYEE table. You need to identify all users who updated the CUSTOMER table on a specific date.
You want to be able to compare the before and after values of each update of the PRICE column of the PRODUCT table. You want to alert the Human Resources Administrator any time someone accesses an executive's salary in the EMPLOYEE table. You want to allow unaudited access to the CONTACT_ ADDRESS column of the CUSTOMER table from within your organization, but track any access to the CONTACT_ADDRESS column that occurs via the Internet. Received on Mon Mar 10 2003 - 19:44:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US