Re: SQL: SET OPTION DYNUSRPRF

Ok, if I have a program in which I already do a
CHGPGM PGM(MYLIB/MYPGM) USRPRF(*OWNER)
If that program has dynamic sql such as
exec sql execute immediate :Cmd;
and I have changed all the files in the application schema to *public
*exclude and I am relying upon "Application Only Access" to get to the data
do I have to change the dynamic sql programs and include
SET OPTION DYNUSRPRF = *OWNER
?


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 7310 Innovation Blvd
Suite 104
Ft. Wayne, IN 46818
Ship to: 7310 Innovation Blvd
Suite 104
Ft. Wayne, IN 46818
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com