OraFAQ Forum: Security » Audit question

Home » RDBMS Server » Security » Audit question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Audit question [message #218883]

Sun, 11 February 2007 20:51

indiana
Messages: 10
Registered: February 2007
Location: China

Junior Member

In order to know which program deletes my table every day, i create a trigger.

CREATE OR REPLACE TRIGGER check_tan
BEFORE DELETE
ON BACKUP.TEST
BEGIN
INSERT INTO audit_result SELECT * FROM v$session;
END;

Warning: TRIGGER created with compilation errors.
ora-00942

where is wrong?

Report message to a moderator

Re: Audit question [message #218914 is a reply to message #218883]

Mon, 12 February 2007 00:53

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

This error means "table or view does not exist". So, BACKUP.TEST, audit_result or v$session does not exist or the current user is not allowed to select from it.

Report message to a moderator

Re: Audit question [message #219090 is a reply to message #218914]

Mon, 12 February 2007 21:20

indiana
Messages: 10
Registered: February 2007
Location: China

Junior Member

question resolved

conn / as sysdba;
grant select on sys.v_$session to backup;

then

CREATE OR REPLACE TRIGGER check_tan
BEFORE DELETE
ON BACKUP.TEST
BEGIN
INSERT INTO audit_result SELECT * FROM v_$session;
END;

trigger created and no wrong.

NOTE:it's v_$session not v$session

Report message to a moderator