No I don't think fga could be a option here. FGA is meant for row level = security.=20 If your just looking for time by which the object definition is changed = or a object is created, then last_ddl_time×tamp columns of = dba_objects will help. If you want to know more than that like which user has changed, from = which machine etc., then ddl triggers will be best option. Thanks and Regards, Satheesh Babu.S Associate Consultant. 080-57593938 Bangalore. India. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mogens N=F8rgaard Sent: Monday, July 12, 2004 3:01 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Capturing Schema changes ?? Setting DML_LOCKS to 0 could also stop it :-). Would FGA be an option here? Mogens Stephane Faroult wrote: > =20 > George,=20 >=20 > If you really want details about what has truly occurred (instead = of > recording that *something* has occurred), I think that DDL triggers = are the > way to go (I don't think that audit has much evolved since at least = the days > of Oracle 5 ...). Beware though that some DDL statements fire several > triggers (eg ALTER TABLE ... ADD CONSTRAINT ... PRIMARY KEY ... if no = index > to enforce the constraint already exists). But for the more trivial = cases, > it can become tricky. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------