Re: SQL package public authority

[Buck Calabro <buck.calabro@xxxxxxxxxxxxxxxxx>]

Gary Monnier wrote:

>> Buck Calabro wrote:
>> I have an interesting question regarding the public 
>> authority the system gives to a newly created SQL 
>> package.
-snip-
>> The nominal fix is to delete the package and let the 
>> machine create a new one, which it does.
>> Unfortunately, at one site, it is created with AUT(*EXCLUDE).

>What profile is creating the package? 
>Is it Carrie, or some other profile?

CARRIE is the owner.  OS/400 is creating the package.
Again, this is not a problem when anybody creates a package using CRTSQLPKG.
It is only a problem when the package is created by OS/400's ODBC support.

Buck Calabro
Aptis; Albany, NY


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