[jira] [Created] (TRAFODION-2796) GET LIBRARIES command does not return libraries where users have privileges on registered udr's

["Roberta Marton (JIRA)" <ji...@apache.org>]

Roberta Marton created TRAFODION-2796:
-----------------------------------------

             Summary: GET LIBRARIES command does not return libraries where users have privileges on registered udr's
                 Key: TRAFODION-2796
                 URL: https://issues.apache.org/jira/browse/TRAFODION-2796
             Project: Apache Trafodion
          Issue Type: Bug
            Reporter: Roberta Marton


The GET LIBRARIES command does not return names for libraries where the current user has privileges on one or more procedures and functions defined within the library.

To recreate:

create schema sch1;
set schema sch1;
--compile a function e.g. found in: .../regress/privs2 (...tools/dll-compile.ksh etest140.cpp)
create library lib1 file '<generated dll-file>';
create function translatePrivsBitmap(bitmap largeint) returns (bitmap_string char (20))
language c parameter style sql external name 'translateBitmap'
library lib1
deterministic no sql final call allow any parallelism state area size 1024 ;
grant execute on function translatePrivsBitmap to sql_user1;

connect as sql_user1:
set schema sch1;
get functions;  -- returns translatePrivsBitmap
get libraries;  -- should return lib1 but returns no libraries.




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)