OraFAQ Forum: Security » Security auditing in oracle 10g One

Home » RDBMS Server » Security » Security auditing in oracle 10g One

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

Security auditing in oracle 10g One [message #150688]

Fri, 09 December 2005 01:12

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

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?

Report message to a moderator

Re: Security auditing in oracle 10g One [message #150993 is a reply to message #150988]

Mon, 12 December 2005 09:00

Mahesh Rajendran
Messages: 10708
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 20:17:37 CST 2025