Encapsulating Stored Procedures with adopted authority

I have a CL program that I'm using as a stored procedure.  I need to put
*SECADM authority on this stored procedure so that when accessed by
users on a Windows server, they are able to run the procedure via a JDBC
connection.  My problem is that I cannot get the authority to work.  I
created the CL program with User: *OWNER and created it with a *SECADM
sign-on.  I see how SQL stored procedures can have SET OPTION USRPRF to
do this but when I try this option for an external procedure it doesn't
work.  I'm simply using the STRSQL console from the iSeries and a CREATE
PROCEDURE statement.  Any ideas?

 

George

_______________________________________________
This is the Security Administration on the AS400 / iSeries (Security400) mailing list
To post a message email: Security400-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/security400
or email: Security400-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/security400.