| Important Security level [message #51498] |
Mon, 27 May 2002 01:49  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
