Re: SQL package public authority

["Gary Monnier" <GaryMon@xxxxxxxxxxxxxxxxxx>]

You are correct.  *PUBLIC authority is 
inherited from QCRTAUT, but only if the library CRTAUT parameter is 
*SYSVAL.  The library I used had CRTAUT set to *EXCLUDE, *PUBLIC as 
*EXCLUDE and QCRTAUT set to *CHANGE.  Any object
created into this 
library was created with *PUBLIC *EXCLUDE.  Forgive my answer.  I 
crossed user authority and CRTAUT.

I did find an APAR - SA77625 - 
relating to your problem though.  Here's the link.

http://as400service.ibm.com/supporthome.nsf/document/10000035

----- 
Original Message -----
From: Buck Calabro <buck.calabro@aptissoftware.com>
To: 
<MIDRANGE-L@midrange.com>
Sent: 
Friday, June 30, 2000 7:47 AM
Subject: Re: SQL package public 
authority


> Gary Monnier wrote:
>
> >Ok, CARRIE 
being the owner implies the
> >package is created under her 
profile.  Now,
> >how is *PUBLIC authority on library QGPL 
set?
>
> QGPL's public authority is *CHANGE, but I thought that only 
limits what I
> can do with QGPL, not the authority that objects created 
there inherit.
> QGPL's LIBCRTAUT is *SYSVAL and system value QCRTAUT is 
*CHANGE.
>
> >If it is *EXCLUDE this is why your package
> 
>is being created with *EXCLUDE authority.
>
> 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.
>
> Buck 
Calabro
> Aptis; Albany, NY
> "We are what we repeatedly 
do.
>  Excellence, then, is not an act, but a habit." 
--Aristotle
>
>
> Billing Concepts Corp., a NASDAQ Listed 
Company, Symbol: BILL
> +---
> | 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
> 
+---