PostGres ROW LEVEL SECURITY with Qlik?

[hjalmars]

I want to make a connection to a PostGres-DB that has RLS (ROW LEVEL SECURITY) enabled. For this purpose I need to set the variable my.data_box_id (session parameter) to some value (e.g. 106) when doing a request to the DB by Qlik. The result will be that the database only returns values that belong to the set in the my.data_box_id session parameter. 

Is there a way to set this parameter (either by transaction or per session) from within Qlik, ideally by using the settings of the Qlik PostgreSQL-Connector?

[Jack_Guo]

Hi @hjalmars not sure if WHERE clause will help by adding to the data load editor SELECT data script.

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Postgr...

[hjalmars]

Hi @Jack_Guo 

Thanks, but I'd rather want to avoid this, because then you must be very careful not to forget any where-statement, otherwise wrong data would be loaded...