Hi @JohnasSolomon
One way is by disabling the restrictions on the protected tables in the dhis.conf configuration file.
system.sql_view_table_protection = on | off
This obviously comes with security risks, but it is one way.
The other way, which I would recommend would be the approach outlined by @Calle_Hedberg here. At least with this route, you do not open potential access to all of the protected tables.
Regards,
Jason