Hi,
I am trying to do a (simple!) CREATE PROCEDURE and finding all sorts of problems. This is an external procedure written in COOL.
I have done a successful pre-compile/compile and link-edit, and copied the plan to both of my testing regions.
I have two regions, one with SECURITY turned on but only for DBDRSSR, the other has none.
In the region with SECURITY on:
I keep getting a -185 ADMAB91 HAS NO CREATE AUTHORITY ON SYSUSR.DCOMEXP
and no apparent way to fix it.
"ADMAB91" has the Dictionary profile $DD-ADM, and I have given that profile every access to PROCEDURE entity, and done a HSD RESET, and I still get the -185.
Has anyone any suggestions?
And in the region with no SECURITY the same CREATE PROCEDURE statement returns this:
SQLCODE = -118, SQLSTATE=RNPNP
MESSAGE = DSF 'NPNP' ERROR OCCURRED DURING SQL DSF PROCESSING
And I can't even find that error code!
TIA.
------------------------------
DBA
Bendigo and Adelaide Bank
South Australia
------------------------------