No problem. BTW, GRANT EXPLAIN will allow explaining everything.
Don't see an obvious exposure with it. On Thu, 27 Nov 2025 02:22:19 +0000 Ron Hesketh <[email protected]> wrote: :>Hi Binyamin, :> There isn't a CREATE SCHEMA statement in DB2 Z/OS m however my apologies, I've had an embarrassingly stupid drastic senior Duffus moment. :> :>The set schema will allow the explain to explain a package that has a Qualifier the same as the SCHEMA name. :> :>The explain statement will use the current SQLID. :>If you give your explain tables an alias of your SQLID, then the explain will find the tables. :> :>I had forgotten that we created one set of explain tables then added an Alais for each user. :>That's how we got around having to allow set current sqlid. :> :>Once again, my apologies for the previous duff information. :> :>Regards, :> Ron :> :> :> :> :> :> :> :>-----Original Message----- :>From: IBM Mainframe Discussion List <[email protected]> On Behalf Of Binyamin Dissen :>Sent: Wednesday, 26 November 2025 9:12 PM :>To: [email protected] :>Subject: Re: DB2 query - is there a way to give a specific permission for a user to SET CURRENT SQLID to another user? :> :>On Tue, 25 Nov 2025 19:50:13 -0600 Jon Perryman <[email protected]> wrote: :> :>:>On Wed, 26 Nov 2025 01:30:16 +0200, Binyamin Dissen <[email protected]> wrote: :> :>:>>The table exists under the the ID that I do a SET CURRENT SQLID. :> :>:>SET SQLID is not valid for your situation because you did not implement the exit. :> :>When the SQLID is a group name and connected to the user it does work. I am trying to avoid this requirement. :> :>:>>Did the SET SCHEMA :> :>:>>DSNT408I SQLCODE = -219, ERROR: THE REQUIRED EXPLANATION TABLE DOES NOT :>>EXIST :> :>:>Notice "TABLE DOES" shows the table name is null. I wonder if it's caused by the invalid SET SQLID. :> :>The SET SCHEMA had SQLCODE 0 :> :>:>>SET SCHEMA was ignored for the EXPLAIN table name. :> :>:>Did you specify AUTHORIZATION 'uuu' on the CREATE SCHEMA where uuu is the name you specified on the SET SQLID? :> :>I can't find the CREATE SCHEMA command in the DB2 V3.1 SQL Reference -- Binyamin Dissen <[email protected]> http://www.dissensoftware.com Director, Dissen Software, Bar & Grill - Israel ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
