Re: SQL package public authority

[theis_richard@xxxxxxxxxx]

Buck wrote:
> I tried creating a package in a library whose public authority is
*EXCLUDE.
> The package inherited the authority from LIBCRTAUT, not the library's
public
> authority.

> The problem here is that the same function (CRTSQLPKG) works differently
> when I run it explicitly as opposed to when the system runs it for an
ODBC
> request.

It has to do with the naming: your ODBC driver is using the *SQL naming,
and you are using the *SYS naming.
Objects created under the *SQL naming are AUT(*EXCLUDE).
Objects created under the *SYS naming are AUT(*LIBCRTAUT).

Perhaps you could change the properties of your ODBC driver (it can be done
with the CA ODBC driver).

Best regards
Richard THEIS
AS/400  Education, France
  theis_richard@fr.ibm.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---