Forum Discussion

AI1995's avatar
AI1995
Frequent Visitor
3 years ago

Logging on data level (after Row Level Security)

Hi all, I have implemented row level security on my reports and I would like to log these (filter) actions for audit reasons. The situation:   Alice views a report being signed in with her email. ...
Data Protection
Need Help
MAwwad's avatar
MAwwad
Solution Sage
3 years ago
 
= VAR CurrentUser = USERPRINCIPALNAME() VAR CurrentFilter = [RLS Filter Measure] INSERT INTO LogTable (Email, Query, Timestamp) VALUES (CurrentUser, CurrentFilter, NOW())
 

This approach will allow you to log the query used by the RLS filter, as well as the email and date and time of access, for each time the report is accessed.

  • AI1995's avatar
    AI1995
    Frequent Visitor
    3 years ago

    Hi DataSlayer,

    thanks for the response, I believe this is exactly what I need. However I do not know how and where to implement this expression. Cloud you show me?