Home » RDBMS Server » Security » Security auditing in oracle 10g One
icon9.gif  Security auditing in oracle 10g One [message #150688] Fri, 09 December 2005 01:12 Go to next message
edas
Messages: 2
Registered: December 2005
Junior Member
Hi, I'm looking for posibilities like grained security auditing (only in Enterprice version) in oracle 10g SE One. Is it possible to log all events like who has viewed exact table at exact time ?

[Updated on: Fri, 09 December 2005 01:40]

Report message to a moderator

Re: Security auditing in oracle 10g One [message #150988 is a reply to message #150688] Mon, 12 December 2005 08:50 Go to previous messageGo to next message
edas
Messages: 2
Registered: December 2005
Junior Member
Maybe I'll ask in other way:

I have Oracle 10g One
Is there a way to log such information:
which user has viewed some data from database
without using fine grained auditing or programming this into application?
Re: Security auditing in oracle 10g One [message #150993 is a reply to message #150988] Mon, 12 December 2005 09:00 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Without some kind of auditing, you cannot~.
FGA is an enhancement of the existing audit procedures (and with different functionalities).
But you need to enable database audit features to capture the information you are looking into.
Something like this

SQL> AUDIT SELECT ON emp;

[Updated on: Mon, 12 December 2005 09:00]

Report message to a moderator

Previous Topic: How to detect which firewall and antivirus exists in server in windows?
Next Topic: Help on using composite limits and resource costs
Goto Forum:
  


Current Time: Thu Mar 28 05:42:28 CDT 2024