Home > IT Answers > AS/400 > I can create a SQL procedure using i series n...
JohnsonMumbai
380 pts.
0
Q:
I can create a SQL procedure using i series navigator but do not have any authority on the procedure.
QSYS.LIB, iSeries Navigator, SQL/400, CPFA09C, COGNOSMIS.LIB, PRTEST111.PGM
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.
ASKED: Aug 28 2008  11:30 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mcl
2500 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
The CPFA09C message indicates you do not have authority to the object OR one of the directories in the object path.

You'll need to talk to your security administrator to get the correct permissions.

Regards
Mike
Last Answered: Aug 29 2008  4:37 PM GMT by Mcl   2500 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0