select object and permissions/access

[BDemeuse]

Hi,

I use "select objects" with data selected from a table. With globeadmin, it works fine but not with users I have defined; the selected list is empty
See PDO message in attachment.
I have checked the access and I do not see where the error can occur.
I have also checked on the forum and a solution is to upgrade nubuilder.
However, I did it last week and it seems working well as I have got the new functionalities

nuBuilder Forte 4.5

DB Version: V.4.5-2022.01.30.00
Files Version: V.4.5-2022.02.02.00

(V.MajorVersion-CurrentDate.BuildNumber)

Thanks in advance

Bri

[kev1n]

"Column not found": Does it actually exist in the db table?

[BDemeuse]

It is a nuBuilder field indeed and I do not understand why it works with globeadmin and not with other users I have defined

[kev1n]

Are you getting the error only when selecting from a specific table or any table?
Globeadmin and normaler users use the same db connection so there shouldn't be any issues.

[BDemeuse]

Hi,

I have 2 environments with the following version
1) DB Version: V.4.5-2021.04.27.00
Files Version: V.4.5-2021.04.26.02
2)DB Version: V.4.5-2022.01.30.00
Files Version: V.4.5-2022.02.02.00

For both version/environment, I get error messages (see below) and not correct behavior for the select objects ( I do not get the values of an internal table, tr_kvp_role)) ONLY for normal user and not when I am logged with globeadmin.

With the version1, the error message is "access violation" for tr_kvp_role (table with the values of the select objects)

with the version2, I get the error "undefined column ... for zzzz_sys_access_form"

Thanks in advance

Bri

[kev1n]

tr_kvp_role is selected twice somehow.
Can you post a screenshot of your browse columns?

[BDemeuse]

I will forget the application with the nuBuilder4 DB Version: V.4.5-2021.04.27.00 because I will migrate anyway.
With the DB Version: V.4.5-2022.01.30.00, here below 3 screenshots
1) with the correct behavior but logged with globeadmin
2) with the incorrect behavior, logged with a normal user
3) the debug messages... there are several, all the same
Thanks

[kev1n]

Can you post a screenshot where I can see your browse column + sql? (CTRL+SHIFT+F, Browse tab)

[BDemeuse]

Hi,

Here the print screen...I have checked everything I thought
Thanks!

[kev1n]

In the Browse screen, inspect the generated SQL (CTRL+SHIFT+I) and post it here.