Home » RDBMS Server » Security » How to find out what date view status changed to invalid (Oracle 10g)
How to find out what date view status changed to invalid [message #498670] Thu, 10 March 2011 15:19 Go to next message
spsbombay
Messages: 29
Registered: June 2007
Junior Member

Hi All,

We are trying to audit a view. We are currently seeing that view in production instance and trying to find out when exactly it got invalidated.

Could you please help.

Regards,
Prashant
Re: How to find out what date view status changed to invalid [message #498673 is a reply to message #498670] Thu, 10 March 2011 15:32 Go to previous messageGo to next message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Audit the alter/drop/create of the underlying objects.

Regards
Michel
Re: How to find out what date view status changed to invalid [message #498675 is a reply to message #498673] Thu, 10 March 2011 15:43 Go to previous messageGo to next message
spsbombay
Messages: 29
Registered: June 2007
Junior Member

Hi Michel,

Thanks for response.
Its a View.. since some package are trying to access this view, we are getting last DDL date as today only.
Could you please advice, if we have any system view or table where we store this data other then dba_objects.

Regards,
Prashant
Re: How to find out what date view status changed to invalid [message #498679 is a reply to message #498675] Thu, 10 March 2011 17:00 Go to previous messageGo to next message
BlackSwan
Messages: 23069
Registered: January 2009
Senior Member
>Could you please advice, if we have any system view or table where we store this data other then dba_objects.
the VIEW may not have changed; underlying table or function may have changed.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: How to find out what date view status changed to invalid [message #498775 is a reply to message #498675] Fri, 11 March 2011 01:27 Go to previous message
Michel Cadot
Messages: 59821
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is neither view nor table. This is not stored.
This is why I advise you to audit the objects on which the view is based.

Regards
Michel

[Updated on: Fri, 11 March 2011 01:28]

Report message to a moderator

Previous Topic: send oracle auditing to syslog
Next Topic: Authenticating Oracle User based on Windows User Id
Goto Forum:
  


Current Time: Fri Nov 28 16:21:47 CST 2014

Total time taken to generate the page: 0.17800 seconds