Re: SQLRPGLE - Authority Problem.

["Chris Beck" <CBeck@xxxxxxxxxxxx>]

Thanks Rob,  
I forgot the DynUsrPrf and UsrPrf. 

Chris 


>>> rob@xxxxxxxxx 06/16/03 11:20AM >>>
How were you doing the adopted authority, with:
     C/EXEC SQL
     C+ Set Option
     C+     Naming    = *Sys,
     C+     Commit    = *None,
     C+     UsrPrf    = *Owner,
     C+     DynUsrPrf = *Owner,
     C+     CloSqlCsr = *EndMod
     C/END-EXEC


http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/db2/rbafzmstsoption.htm#HDRSOPTION
 


Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 





"Chris Beck" <CBeck@xxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx 
06/16/2003 11:06 AM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     <rpg400-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        SQLRPGLE - Authority Problem.


I have a SQLRPGLE program that uses a cursor.  The file that the cursor 
select is on has public *EXCLUDE, but we use Adopted authority.  The 
program will not work unless I have *allobj, or specific rights to the 
file. I checked the adopted authority settings, and they are working for 
everything else.  Why does the program not use the Adopted authority?



Thanks 

Chris 



_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l 
or email: RPG400-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l 
or email: RPG400-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.