RE: SQL0551 Error when running SQLRPGLE program

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

Best way to handle it is not to change the compiler default but add this
in your code:

c/exec sql
C+  Set option dynusrprf = *OWNER
c/end-exec

Then when you upgrade OS levels you won't have to remember to change the
compiler default again ;) 


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:55 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: SQL0551 Error when running SQLRPGLE program

Bingo!  That was it!

I knew it was something simple.  I'll change the command default while I

am at 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
>