Not able to create procedures using STRSQL on V6R1

215 pts.
Tags:
AS/400 DB2
AS/400 SQL
iSeries V6R1
STRSQL
While creating a procedure in V6R1, [strong]Not authorized to CREATE PROCEDURE error (Message ID is SQL0552)[/strong] appears. In Additional Message Information cause of the error being -- [strong]CREATE PROCEDURE or CREATE FUNCTION requires the *OBJOPR and *ADD authority to the catalog table SYSROUTINES in QSYS2[/strong].

However [strong]PUBLIC[/strong] has [strong]*CHANGE[/strong] Authority on [strong]QSYS2/SYSROUTINE[/strong] Object. Please note my id does not have *ALLOBJ Authority.



Software/Hardware used:
V6R1M0, iSeries 570

Answer Wiki

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

You need to work with your SysAdm to get the authority you need.

Discuss This Question: 2  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
  • TomLiotta
    Are any Authority Failure (T/AF) entries generated into the system audit journal? If so, do all of the reported values match up with your expectations? (For example, is the failing user profile reported as your profile?) On the surface, *PUBLIC *CHANGE would seem to be sufficient. Tom
    125,585 pointsBadges:
    report
  • Haaiderali
    [...] 1. CharlieBrowne and TomLiotta helped a member who’s not able to create procedures using STRSQL on V6R1. [...]
    0 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