OraFAQ Forum: Security » How can audit in details

Home » RDBMS Server » Security » How can audit in details

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

How can audit in details [message #62382]

Sun, 18 July 2004 22:19

ngo van thang
Messages: 2
Registered: July 2004

Junior Member

Hello,

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

Report message to a moderator

Re: How can audit in details [message #62384 is a reply to message #62382]

Mon, 19 July 2004 00:20

Maaher
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.

MHE

Report message to a moderator

Re: How can audit in details [message #62408 is a reply to message #62384]

Tue, 20 July 2004 17:55

nvtnow
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.

Report message to a moderator

Previous Topic:	grant privileges
Next Topic:	Oracle Authentication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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