GRANT syntax for SHOWDDL output incorrect

[Roberta Marton]

There are several issues related to SHOWDDL of functions.

If SHOWDDL function <name> is performed and authorization is not enabled, then the operations should succeed, instead the following error is reported:

showddl function translateBitmap;

*** ERROR[4082] Object TRAFODION."_PRIVMGR_MD_".OBJECT_PRIVILEGES does not exist or is inaccessible.

If SHOWDDL function <name> is performed then the GRANT output is incorrect:
the keyword FUNCTION is needed before the function name.

CREATE FUNCTION TRAFODION.SCH.T134_TRANSLATEPRIVSBITMAP
  (
    IN BITMAP LARGEINT
  )
  RETURNS
  (
    OUT BITMAP_STRING CHAR(20) CHARACTER SET ISO88591
  )
 . . .
  SAFE EXECUTION MODE
  ;

-- GRANT EXECUTE ON TRAFODION.SCH.T134_TRANSLATEPRIVSBITMAP TO DB__ROOT WITH GRANT OPTION;
  GRANT EXECUTE ON TRAFODION.SCH.T134_TRANSLATEPRIVSBITMAP TO SQL_USER2;

If a privilege is granted to PUBLIC, then the GRANT statement is incorrect, PUBLIC should be enclosed in double quotes:

CREATE FUNCTION TRAFODION.SCH.T134_TRANSLATEPRIVSBITMAP
  (
    IN BITMAP LARGEINT
  )
  RETURNS
  (
    OUT BITMAP_STRING CHAR(20) CHARACTER SET ISO88591
  )
  . . .
  SAFE EXECUTION MODE
  ;

-- GRANT EXECUTE ON TRAFODION.SCH.T134_TRANSLATEPRIVSBITMAP TO DB__ROOT WITH GRANT OPTION;
  GRANT EXECUTE ON TRAFODION.SCH.T134_TRANSLATEPRIVSBITMAP TO PUBLIC;
GRANT
  EXECUTE ON TRAFODION.SCH.T134_TRANSLATEPRIVSBITMAP TO SQL_USER2;

[Roberta Marton (roberta-marton)]

Fixed the OBJECT_PRIVILEGES error returned
But public does not need to be enclosed in double quotes. The code handles this name correctly.