Home » RDBMS Server » Security » How to know the last access to a table?
How to know the last access to a table? [message #320182] Wed, 14 May 2008 04:42 Go to next message
iblazquez
Messages: 26
Registered: June 2007
Junior Member
Is there any way to know when was the last access (Query, procedure...) to a table.

Thanks.
Re: How to know the last access to a table? [message #320184 is a reply to message #320182] Wed, 14 May 2008 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on your Oracle version.
- Log Miner
- Flashback transaction query

Regards
Michel
Re: How to know the last access to a table? [message #320192 is a reply to message #320184] Wed, 14 May 2008 04:58 Go to previous messageGo to next message
iblazquez
Messages: 26
Registered: June 2007
Junior Member
Thanks for your fast reply.

I have Oracle 9i and Oracle 10. I'd like to know if oracle has any table with this information.
Re: How to know the last access to a table? [message #320197 is a reply to message #320192] Wed, 14 May 2008 05:11 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Flashback transaction query

Search for this in documentation.

But if you know you'll need to know this, you should activate auditing on this table.

Regards
Michel

[Updated on: Wed, 14 May 2008 05:12]

Report message to a moderator

Previous Topic: Auditing DML - Terminal
Next Topic: Transparent Data Encryption
Goto Forum:
  


Current Time: Thu Mar 28 19:26:03 CDT 2024