IC68517: DBEXPORT PRINTS OUT REVOKE STATEMENTS FOR PUBLIC PROCEDURES/FUNCTIONS

APAR status

• Closed as program error.

Error description

• As a result of APAR IC65385 dbexport now prints out REVOKE
  statements for procedures/functions.
  Unfortunately it generates REVOKE statements also for public
  procedures/functions.
  
  This causes dbimport to fail with
  
  revoke  execute on procedure "public".myproc () from public as
  "public";
  *** execute sqlobj
  580 - Cannot revoke permission.
  
  111 - ISAM error:  no record found.
  
  Example:
  
  create function "public".myfunc() returning int
  return 99;
  end function;
  
  create procedure "public".myproc()
  end procedure;
  
  dbschema generates the following revoke statements:
  
  revoke  execute on procedure "public".myproc () from public as
  "public";
  revoke  execute on function "public".myfunc () from public as
  "public";
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All platforms                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * dbexport prints out REVOKE statements for public             *
  * procedures/functions.                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC8.                                        *
  ****************************************************************
  

Problem conclusion

• Fix was checked into 11.50.xC8.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP