| Audit specific statment on specific table by specific user [message #555871] |
Tue, 29 May 2012 09:41  |
 |
Karlia
Messages: 40 Registered: May 2011 Location: Algiers
|
Member |
|
|
Hello everybody,
I'd like to know if it is possible to track DML actions issued on a specific table by a specific user, for example , i tried :
AUDIT SELECT on SCOTT.DEPT by HR by ACCESS;
I get an error, where is my syntax error ?
Please don't say me to create a trigger, i want to know if it's possible to do it without trigger ?
Thanks.
|
|
|
|
|
|
|
|
|
|
| Re: Audit specific statment on specific table by specific user [message #555905 is a reply to message #555902] |
Tue, 29 May 2012 15:29   |
 |
Karlia
Messages: 40 Registered: May 2011 Location: Algiers
|
Member |
|
|
I mean :
when i want to track all INSERTs and UPDATEs on SCOTT.EMP i have just to issue :
AUDIT INSERT, UPDATE on SCOTT.EMP
On the other hand,o
to track all INSERTs adn UPDATEs issued by HR, we have only to execute :
AUDIT INSERT TABLE, UPDATE TABLE by HR
but the first auditing generates entries when INSERTs and UPDATEs are executed on EMP by every user , not only HR, while in the second auditing , all INSERTs and UPDATEs done by HR are tracked not only those that concern SCOTT.EMP
So, according to MICHEL, to audit just what is issued by HR on only SCOTT.EMP, we have to user triggers , am i right ?
|
|
|
|
|
|
|
|
|
|