I can create a SQL procedure using i series navigator but do not have any authority on the procedure.

1160 pts.
Tags:
iSeries Navigator
QSYS.LIB
SQL/400
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following