Database Software

Hello,

I want to audit all DDL commands from all users on all objects within a schema .

I think .. The best way is to use a triggger like :

under sys user:

CREATE TABLE AUDIT_DDL ... ;

CREATE OR REPLACE TRIGGER after ddl
ON toto.SCHEMA
begin
...
insert into audit_ddl....
..
end;


then i connect with toto and create a table .

I can see my create statment.

But if i create a table in schema toto with another user like SYS or SYSTEM i can't see the create statement..

Could you please help me?

any idea?

CAn i use an audit trail function instead of this trigger? (i think no..)

Thanks