× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I realized belatedly that my previous post may not have been relevant.

I also realize you have probably already looked at the help text for the
message, but this is in the help for SQL0552

-- CREATE TRIGGER requires *USE authority to the ADDPFTRG command.

Paul

On 2017-04-06 10:43, Paul Therrien wrote:

Found this w/Google...

You might see message SQL0552 when creating a SQL Stored Procedure
because authority is lacking to the SQL Catalog tables. Ensure that
public authority on QSYS2/SYSPROCS is set to *USE and QSYS2/SYSPARMS is
set to *CHANGE, or you can refer to the following for additional
information on the required authorities:

https://www-304.ibm.com/support/entdocview.wss?uid=nas8N1013930

Paul

On 2017-04-06 09:32, Rob Berendt wrote:

Person on another machine outside of my direct control.
STRSQL
CREATE TRIGGER...
SQL0552 - Not authorized to ADDPFTRG.

Signed on as user with *ALLOBJ.
They can do DSPOBJD ADDPFTRG *CMD and see the command

IBM i 7.3. Little behind on PTF's. DB group = level 1.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.