Home > IT Answers > AS/400 > Not able to create procedures using STRSQL on V6R1
Haaiderali
215 pts.
 Not able to create procedures using STRSQL on V6R1
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
ASKED: August 22, 2011  7:22 AM
UPDATED: March 31, 2012  5:56 PM
RELATED QUESTIONS
Answer Wiki:
You need to work with your SysAdm to get the authority you need.
Last Wiki Answer Submitted:  August 22, 2011  1:36 pm  by  CharlieBrowne   32,905 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,905 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

TomLiotta
 108,225 pts.