Home » SQL & PL/SQL » SQL & PL/SQL » Sytem Triggers at Database level
Sytem Triggers at Database level [message #254133] Wed, 25 July 2007 19:42 Go to next message
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
Re: Sytem Triggers at Database level [message #254163 is a reply to message #254133] Thu, 26 July 2007 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As it, it tracks CREATE of any object in any schema.

Regards
Michel
Re: Sytem Triggers at Database level [message #254283 is a reply to message #254133] Thu, 26 July 2007 06:31 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Who were you logged in as when you created the table, not the trigger.
Previous Topic: query
Next Topic: min(rowid)
Goto Forum:
  


Current Time: Wed Feb 12 18:10:42 CST 2025