[
https://issues.apache.org/jira/browse/TRAFODION-1216?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14706900#comment-14706900
]
Roberta Marton commented on TRAFODION-1216:
-------------------------------------------
Fixed the OBJECT_PRIVILEGES error returned
But public does not need to be enclosed in double quotes. The code handles this
name correctly.
Fix has been delivered.
> LP Bug: 1450200 - GRANT syntax for SHOWDDL output incorrect
> -----------------------------------------------------------
>
> Key: TRAFODION-1216
> URL: https://issues.apache.org/jira/browse/TRAFODION-1216
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-security
> Reporter: Roberta Marton
> Assignee: Roberta Marton
> Priority: Critical
> Fix For: 2.0-incubating
>
>
> 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;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
