OraFAQ Forum: Security » How to find out what date view status changed to invalid

Home » RDBMS Server » Security » How to find out what date view status changed to invalid (Oracle 10g)

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

How to find out what date view status changed to invalid [message #498670]

Thu, 10 March 2011 15:19

spsbombay
Messages: 28
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

Report message to a moderator

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

Michel Cadot
Messages: 54127
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Audit the alter/drop/create of the underlying objects.

Regards
Michel

Report message to a moderator

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

spsbombay
Messages: 28
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

Report message to a moderator

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

BlackSwan
Messages: 20086
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/

Report message to a moderator

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

Michel Cadot
Messages: 54127
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 00:43:48 CDT 2013

Total time taken to generate the page: 0.14539 seconds