You can translate the question and the replies:

input_privilege column Missing in get_elements() store procedure

we have two denodo installation with same version(8.0.20220126) in two different machines. If we call get_elements() store procedure from machine 1, we getting **24 columns** in resultset. But when we call the same get_elements() store proc from machine 2, we getting only **23 columns** in resultset. This is how we call - *SELECT FROM get_elements()* **input_privilege** column is missing from machine 2 resultset, how to get this column in resultset?
07-02-2023 10:03:59 -0500

2 Answers

Hi, The results of the [GET_ELEMENTS]( stored procedure change depending on the privileges granted to the user that runs it. I ran ‘SELECT * from get_elements()’ as an admin user and my resultset contained all 24 columns. Check to see if the user running the stored procedure has the same permissions (roles and privileges) in each Denodo server. Additionally, you can run the stored procedure as an admin user from each VDP instance to see if the results are consistent. If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
07-02-2023 16:51:26 -0500
Both denodo server have same admin user to run this Query, same permissions (roles and privileges). I will create support case shortly.
08-02-2023 10:03:38 -0500
You must sign in to add an answer. If you do not have an account, you can register here