Visualization issues for different users of DB

[cacereslab]

Apparently different users do not see the same in information when they log on in the private DB. In the case of the general lab user, David Castellano has seen that there are only 5-10 inversions with frequency in the list, when with my user I see around 70.

[lpantano]

I confirm the issue. Actually in the development version users from invfestdb-lab cannot see any inversions. I think that this is an urgent issue, we need to get development and stable versions behave the same way. I can help if you explain me where is the code involved in that process.

[lpantano]

the problem is user permissions. invfestdb-lab need to have permissions for INVFEST-DB-dev

[lpantano]

I think that line 462 has something to say. At INVFEST-DB-PUBLIC the column frequency_distribution has value 52;17;0.1569 At INVFEST-DB the column frequency_distribution has value NULL with user mcaceres, line 462 doesn't give any warnings, with lab users give warnings.

Since this is a function of mysql, I am thinkin of permission of user invfestdb-lab with some functions. Just check which users has which permissions.

[lpantano]

ERROR 1370 (42000): execute command denied to user 'invfestdb-lab'@'%' for routine 'INVFEST-DB.inv_frequency'

[lpantano]

solved:

GRANT EXECUTE on * TO 'invfestdb-lab'@'%' identified by 'InvFESTLab';