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.

Report message to a moderator

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: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It depends on your Oracle version.
- Log Miner
- Flashback transaction query

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

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: 68776
Registered: March 2007
Location: Saint-Maur, France, https...
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 12 00:04:00 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.