Package Creator

Jim Rice

Package Creator
When is the creator column in SYSPACKAGE updated? Bind time and re-bind time?

The reason I ask is we have some packages that show a creation time of back in 2001, but the id shown as owner didn't exist until 2011.

Thanks.

Jim

Roy Boxwell

Package Creator
(in response to Jim Rice)
Found this:

Dynamic and static SQL can influence ownership of an object. In general, if you use dynamic SQL to create an object, the owner is the value of the current SQL ID. The current SQL ID identifies what ID you are associated with. If you use static SQL, you can specify the owner when you bind the plan or package. If you do not specify an owner, the binder’s primary ID becomes the owner. Unless you specify the QUALIFIER option, the owner’s ID becomes the high-level qualifier of the unqualified objects created and must possess all of the privileges needed to create the objects.

So it looks like a bind/rebind transferred ownership at some time.

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de
Link zur Datenschutzerklärung

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

> On 3 Jun 2019, at 16:11, Rice, James L. (Jim) <[login to unmask email]> wrote:
>
> When is the creator column in SYSPACKAGE updated? Bind time and re-bind time?
>
> The reason I ask is we have some packages that show a creation time of back in 2001, but the id shown as owner didn’t exist until 2011.
>
> Thanks.
>
> Jim
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Visit ESAi at IDUG Charlotte. Enter drawings & learn about BCV4, BCV5, Masking Tool, BPA4DB2...
> great automated solutions for Cloning, Buffer Pool Tuning, Log processing, TDM & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
Attachments

  • smime.p7s (3.9k)