Re: SQL0551 Error when running SQLRPGLE program

Bingo!  That was it!

Thanks,

Pete


Holden Tommy wrote:

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