Re: SQL package public authority -- MIDRANGE-L

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
> +---

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.