finding out when procedure created

Posted in 2012

Topics: Security, Permissions & Auditing

KARL OLIVER — Thu, 19 Apr 2012 22:21:35 — source: IIUG Forums & Mailing Lists

help please I want to know how to find out when procedure created. I thought it would be in table sysprocedures,cant see it though. The audit file shows date it was dropped and created. I want to confirm this.

↪ replying to KARL OLIVER

Art Kagel — Thu, 19 Apr 2012 22:40:07 — source: IIUG Forums & Mailing Lists

Not recorded on the database catalog. You would have to look through the logical log records. Art On Apr 19, 2012 6:21 PM, "KARL OLIVER" <karl.oliver@maf.govt.nz> wrote: > help please > I want to know how to find out when procedure created. > I thought it would be in table sysprocedures,cant see it though. > The audit file shows date it was dropped and created. I want to confirm > this. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b15a58b6820b104be0fdab1

↪ replying to Art Kagel

Plugge, Joe R. — Thu, 19 Apr 2012 23:06:29 — source: IIUG Forums & Mailing Lists

I am not alone here when I say that would be a welcomed feature enhancement if the creation date for the procedure/function was tracked in the system catalog. ________________________________________ From: ids-bounces@iiug.org [ids-bounces@iiug.org] On Behalf Of Art Kagel [art.kagel@gmail.com] Sent: Thursday, April 19, 2012 5:40 PM To: ids@iiug.org Subject: Re: finding out when procedure created [26759] Not recorded on the database catalog. You would have to look through the logical log records. Art On Apr 19, 2012 6:21 PM, "KARL OLIVER" <karl.oliver@maf.govt.nz> wrote: > help please > I want to know how to find out when procedure created. > I thought it would be in table sysprocedures,cant see it though. > The audit file shows date it was dropped and created. I want to confirm > this. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --047d7b15a58b6820b104be0fdab1 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Plugge, Joe R.

KARL OLIVER — Fri, 20 Apr 2012 03:24:52 — source: IIUG Forums & Mailing Lists

yes I agree Joe. seems strange date is not recorded