Server side functionality objects need improved authorities

[m-tyler]

I am receiving this error now...

The SQL procedure was defined by a contract programmer from Profound Logic. I don't have authority to review permissions but the service jobs don't report any errors running this procedure since the service jobs are connected using QSECOFR.

Realistically, I or other user don't need to continue to create this procedure once created. I would recommend checking for the existence first. If it ever comes to pass that this toll needs to no longer use QSECOFR as the initial service job profile, you will need to use the GRANT SQL statement to allow others to use the procedure.

I tried to run the procedure using ACS RSS under my authorities and I get SQL0440 error.

---

Context	Version
Code for IBM i version	2.8.0
Visual Studio Code version	1.86.2
Operating System	win32_x64

Active extensions

Auto Hide (fork) (vscode-autohide-fork): 1.0.9
Calculator (calculator): 0.1.1
Code Spell Checker (code-spell-checker): 3.0.1
Code for IBM i Walkthroughs (vscode-ibmi-walkthroughs): 0.4.0
Db2 for IBM i (vscode-db2i): 0.8.0
Emmet (emmet): 1.0.0
Error Lens (errorlens): 3.16.0
Excel Viewer (gc-excelviewer): 4.2.59
Git (git): 1.0.0
Git Base (git-base): 1.0.0
GitHub (github): 0.0.1
GitHub Authentication (github-authentication): 0.0.2
IBM i Notebooks (vscode-ibmi-notebooks): 0.0.6
JSON Language Features (json-language-features): 1.0.0
Merge Conflict (merge-conflict): 1.0.0
Node Debug Auto-attach (debug-auto-launch): 1.0.0
Overtype (overtype): 0.5.0
Partial Diff (partial-diff): 1.4.3
RPGLE (vscode-rpgle): 0.26.2
Rainbow CSV (rainbow-csv): 3.11.0
TODO Highlight (vscode-todo-highlight): 1.0.5
Text Marker (Highlighter) (text-marker): 1.11.0
TypeScript and JavaScript Language Features (typescript-language-features): 1.0.0
undefined (indent-rainbow): 8.3.1

---

Remote system

Setting	Value
IBM i OS	V7R5M0
Tech Refresh	3
CCSID	37
Default CCSID	37
SQL	Enabled
Source dates	Enabled

Enabled features

/QOpenSys/pkgs/bin	/usr/bin	/QSYS.lib/ILEDITOR.lib	/QSYS.LIB	/QIBM/ProdData/IBMiDebugService/bin
bash	attr	GENCMDXML.PGM	QZDFMDB2.PGM	startDebugService.sh
git	iconv
grep	setccsid
ls
md5sum
sort
stat
tar
tn5250

Shell env

BUILDLIB=PGMT
CURLIB=PGMT
HOME=/home/PGMT
HOST=400devl.go.winco.local
LIBLS=QDEVTOOLS QTEMP QGPL HAWKEYE WFISRC AFPTOOL SPLTOOL TAATOOL WFIOBJ WFIHST WFINEP WFIDTA DTSDCDTA DTSCNTRL DTSUSER DEVSRC DEVOBJ DEVDTA WSBSRC WSBOBJ WSBDTA DEVQUAL WSBUSR WIASPUSR D2CVTPROD D2CVTQUAL D2CVTINTG D2WFIPROD D2WFIQUAL D2WFIINTG D2DTSPROD D2DTSPRODC D2DTSPRD92 D2DTSQUAL D2DTSQUA92 D2DTSINTG D2DTSINT92 D2SYSPROD D2SYSQUAL D2SYSINTG PGMT
LMI_REL_IDLIB=D2WFIPROD
LMI_REL_IDLIBS=D2WFIPROD,D2CVTPROD
LOGIN=pgmt
LOGNAME=pgmt
MAIL=/var/spool/mail/pgmt
NUMPCR=1708800,1976200,1935500,1919800
OLDPWD=/home/PGMT
PATH=/QOpenSys/pkgs/bin:/QOpenSys/usr/bin:/usr/ccs/bin:/QOpenSys/usr/bin/X11:/usr/sbin:.:/usr/bin
PCR=PCR1708800,PCR1976200,PCR1935500,PCR1919800
PROFILENAME=D2:PCR:17088-00
PWD=/home/PGMT
REL=D2WFI
SHELL=/QOpenSys/pkgs/bin/bash
SHLVL=1
TZ=<MST>7<MDT>,M3.2.0,M11.1.0
USER=pgmt
USERNAME=PGMT
WORKDIR=/home/PGMT
_=/QOpenSys/pkgs/bin/env

Variants

{
  "american": "#@$",
  "local": "#@$"
}

Errors

[
   {
    "command": "/QOpenSys/usr/bin/qsh",
    "code": 1,
    "stderr": "CPC7301:  File QSQLSRC created in library QTEMP.\nCPC7303:  File QSQLSRC in library QTEMP changed.\nCPC7305:  Member GETNEWLIBL added to file QSQLSRC in QTEMP.\nSQL0551:  Not authorized to object GETNEWLIBL in ILEDITOR type *PGM.\nSQL0551:  Not authorized to object GETNEWLIBL in ILEDITOR type *PGM.\nSQL9010:  RUNSQLSTM or RUNSQL command failed.",
    "cwd": "/"
  }
]