Authorization problem on DDM file in RPG program

pts.
Tags:
IBM DB2
RPG
Security
I have a RPG program that accesses three DDM files on another iSeries. The program compiles, but I receive error CPF9822-Not authorized to file XXXX in library XXXX. Cannot open DDM file. I have *SECOFR rights on both machines. Can someone help me?

Answer Wiki

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

I dont think special authority *SECOFR will help in this case. You need a user profile on the target machine that has specific authority to the object. View the authority to the object with DSPOBJAUT.

=====================================================

It will depend on how your DDM is configured, SNA or IP. Nowadays, DDM over IP will be easier. For IP:

Ensure that passwords are required. (Otherwise the system can be totally open to the world.)
Use the Add Server Authentication Entry (ADDSVRAUTE) command to set an entry on the source system that will control the profile used on the target system; review the help text to see the server name for DDM.

Next time you connect, the authentication entry will send a logon request for you. The transaction will run under the logon profile.

Be aware that only a single authentication entry can exist for DDM regardless of what the target system is.

Tom

Discuss This Question: 5  Replies

 
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
  • Freckles
    Thanks for the response, but I have full authority to this file on the other iSeries.
    0 pointsBadges:
    report
  • Drich400
    You may need to look at the DDM defaults. Type CFGTCP, take option 20 (Configure TCP/IP applicatons) take option 5 (Change DDM TCP attributes). Check to see if the password is required. Try setting this option to *NO, and try again.
    0 pointsBadges:
    report
  • Freckles
    Thank you for your response, but it did not work.
    0 pointsBadges:
    report
  • Rjkunz4
    I have found that the ID must be the same on both machines.
    0 pointsBadges:
    report
  • TomLiotta
    Next time this happens, show us the AF (Authority Failure) entry from the system audit journal on the remote system. The cause will probably be seen in the entry. Tom
    125,585 pointsBadges:
    report

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