RE: SQL0551 Error when running SQLRPGLE program

On compiling use USRPRF(*OWNER) & DYNUSRPRF(*OWNER)  seems that the SQL
in the program uses the DYNUSRPRF setting for authority which defaults
to *USER. 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Helgren
Sent: Wednesday, June 07, 2006 3:17 PM
To: RPG Midrange Discussion
Subject: SQL0551 Error when running SQLRPGLE program

I am not sure what I am missing here.  I have two SQLRPGLE programs that

I have written that run OK when the user has *ALLOBJ authority but I get

an SQL0551 error when run with user level security.  Normally I compile 
the program with *OWNER User Profile and I don't have a problem.  The 
files and the programs are all owned by the same user and I use adopted 
authority.

But something is not working the same here.  These programs have *OWNER 
user profile, Use Adopted Authority *YES and are owned by the proper 
user profile but they still get the "Not authorized to object XXX in XXX

type *FILE" error.  What did I miss?

Pete Helgren