Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
antonysnow
Contributor
Contributor

Identity assertion into a database

Hi there,

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.  So the logged-in username can be asserted into the database and row-level security can be enforced by the database.

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

Can this be done in QlikSense?  Please show me how.  This is a necessary feature for us to consider a BI product.

Antony.

Labels (1)
0 Replies