Sytem Triggers at Database level [message #254133] |
Wed, 25 July 2007 19:42  |
swapnajojo
Messages: 40 Registered: June 2007 Location: India
|
Member |
|
|
I have created a trigger as scott as user
Create or replace trigger systrig41
after create on schema
begin
Insert into Audit_track values
('table created '||''||current_timestamp);
Insert into Auditmaster ( obj,typ,created_date)
values (sys.dictionary_obj_name ,sys.dictionary_obj_type,sysdate);
end;
I have created a table in scott schema?
Does this doesnt populate vaues into the below tables
1)Audit_track
2) Auditmaster
if not how should this trigger be modified ao as to
track it in system schema
|
|
|
|
|