Re: STRSQL, CREATE TRIGGER results in SQL0552

[Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>]

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