Re: STRSQL, CREATE TRIGGER results in SQL0552

Got it.

Paul

On 2017-04-06 10:52, Rob Berendt wrote:

This person had *ALLOBJ. So access to ADDPFTRG was not an issue. When
you specify SECURED on your CREATE TRIGGER there's something at the bottom
of that help that kicks in. See other reply.

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

From: Paul Therrien <paultherrien@xxxxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Cc: Rob Berendt <rob@xxxxxxxxx>
Date: 04/06/2017 10:50 AM
Subject: Re: STRSQL, CREATE TRIGGER results in SQL0552
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD