Home » RDBMS Server » Security » Important Security level
Important Security level [message #51498] Mon, 27 May 2002 01:49 Go to next message
Shrikanth
Messages: 16
Registered: April 2002
Junior Member
i have a live critical database running on solaris what i want is i want to track the user the time and the type of object which a user tries to drop from the database using the trigger. for that i have written a trigger but the problem is it is giving me some error.the trigger code is this

CREATE OR REPLACE TRIGGER DDLTrigger
AFTER Drop ON DATABASE
BEGIN
INSERT INTO DDLEvents
(UserName, DDLDate, DDLObjType, DDLObjOwner, DDLObjName, DDLEvent) VALUES
(ora_login_user, sysdate, ora_dict_obj_type,
ora_dict_obj_owner, ora_dict_obj_name, ora_sysevent);
END;

can u help me on this.. you can do neccessary changes to the code and kinldy mail it please.. it is really important for me..
thanks in advance

shrikanth
Re: Important Security level [message #51501 is a reply to message #51498] Mon, 27 May 2002 05:18 Go to previous message
Alex Shenfield
Messages: 15
Registered: May 2002
Junior Member
Hi,
Why not setup Auditing, it quick simple and works?
Previous Topic: Auditing Problem . Pls help me
Next Topic: How to audit a table
Goto Forum:
  


Current Time: Thu May 26 16:17:19 CDT 2022