topic Re: PostGres ROW LEVEL SECURITY with Qlik? in App Development

PostGres ROW LEVEL SECURITY with Qlik?

hjalmars — Fri, 01 Nov 2024 14:13:21 GMT

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?

Re: PostGres ROW LEVEL SECURITY with Qlik?

Jack_Guo — Tue, 05 Nov 2024 03:49:51 GMT

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/PostgresSQL/Load-PostgresSQL-data.htm

Re: PostGres ROW LEVEL SECURITY with Qlik?

hjalmars — Tue, 05 Nov 2024 11:01:29 GMT

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...