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
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
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
> Site Links: View post online View mailing list online Start
new thread via email Unsubscribe from this mailing list Manage your
> 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.
> Use of this email content is governed by the terms of service