https://community.qlik.com/t5/Connectivity-Data-Prep/Identity-assertion-into-a-database/m-p/2090289#M12463 <P>Hi there,</P> <P>Most BI tools like Oracle's OBIEE and SAP's BOXI have a way to configure a data source where a database stored procedure can be called to initialise the database context. &nbsp;So the logged-in username can be asserted into the database and row-level security can be enforced by the database.</P> <P>For example in SAP's BOXI, there is a connection property called "ConnectionInit" and you can call a procedure to assert the BOXI username into it: "BEGIN my_database_context.init('@Variable('BOUSER')'); END;".</P> <P>Can this be done in QlikSense? &nbsp;Please show me how. &nbsp;This is a necessary feature for us to consider a BI product.</P> <P>Antony.</P> Tue, 04 Jul 2023 10:32:19 GMT antonysnow 2023-07-04T10:32:19Z https://community.qlik.com/t5/Connectivity-Data-Prep/Identity-assertion-into-a-database/m-p/2090289#M12463 <P>Hi there,</P> <P>Most BI tools like Oracle's OBIEE and SAP's BOXI have a way to configure a data source where a database stored procedure can be called to initialise the database context. &nbsp;So the logged-in username can be asserted into the database and row-level security can be enforced by the database.</P> <P>For example in SAP's BOXI, there is a connection property called "ConnectionInit" and you can call a procedure to assert the BOXI username into it: "BEGIN my_database_context.init('@Variable('BOUSER')'); END;".</P> <P>Can this be done in QlikSense? &nbsp;Please show me how. &nbsp;This is a necessary feature for us to consider a BI product.</P> <P>Antony.</P> Tue, 04 Jul 2023 10:32:19 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Identity-assertion-into-a-database/m-p/2090289#M12463 antonysnow 2023-07-04T10:32:19Z