Home » RDBMS Server » Security » How can audit in details
How can audit in details [message #62382] Sun, 18 July 2004 22:19 Go to next message
ngo van thang
Messages: 2
Registered: July 2004
Junior Member

I Have a question about system audit,

At current, with option 'Audit_trail' . I can recognize who login to my system. But i want for further that i can know which data they take form which table and schema. how can i do it ?

Any Expert can show me the trigger or the someways that can do it. Thank so much!

At present, I use Oracle 8i Enterpise, Windows 200 Server
Re: How can audit in details [message #62384 is a reply to message #62382] Mon, 19 July 2004 00:20 Go to previous messageGo to next message
Messages: 7064
Registered: December 2001
Senior Member
In Oracle 8i, you can audit dml statements per table:
SQL> audit insert, update on emp;

Audit succeeded.

Re: How can audit in details [message #62408 is a reply to message #62384] Tue, 20 July 2004 17:55 Go to previous message
Messages: 5
Registered: April 2004
Junior Member
Hi Maaher,
I did as you guided. But i dont know which table store adit data?
Do i need enable some parameter?
thanks for your help.
Previous Topic: grant privileges
Next Topic: Oracle Authentication
Goto Forum:

Current Time: Fri Dec 09 03:30:24 CST 2022