Re: STRSQL, CREATE TRIGGER results in SQL0552

[Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

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