To: ibescos 
Subject: Auditing Syntax

On Fri, 10 Sep 1999, ibescos wrote:
> Ari this is a very helpful site Thank you so much for your time and effort
> 
> I had been ask to evaluate how to audit the Objects on the database who is
> accessing them etc.. One of the main concerns is the issue with performance
> and the SQL appropriate to achieve this. Can you help me ?
> 
> Thank you so much in advance
> I hope to hear from you shortly 
> Kind Regards
> Isabel
> 

Isabel,

You need to use the AUDIT functionality of Oracle. There are 159 different
actions that can be audited by Oracle (object, privilege, and statement
categories). The syntax is:

AUDIT audit_option [ON schema.object_name] [BY username]
                   [BY { SESSION | ACCESS }]
                   [WHENEVER { SUCCESSFUL | NOT SUCCESSFUL }]


For example,

AUDIT SELECT, INSERT ON SCOTT.EMP;

will generate auditing whenever someone issues a SELECT or INSERT against
the EMP table in the SCOTT schema.


The SYS.AUD$ table contains all auditing information. To view:

SELECT * FROM SYS.AUD$;

Best regards,

-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 335+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             http://www.arikaplan.com                          <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page n.com"> Back to Ari Kaplan's Home Page