I can create a SQL procedure using i series navigator but do not have any authority on the procedure. When i view the procedure on i series navigatore it show that iam the Definer, however when i try to change the permissions on the procedure i get following message CPFA09C Not authorized to object. OBJECT IS /QSYS.LIB/COGNOSMIS.LIB/PRTEST111.PGM
My As400 user profile belongs to *USER class with *NONE as special authorities.
I wish to work on SQL procedures using I series navigator rather that using the As400 command line.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!