Rowlevel Security on AUDIT_VISUALANALYTICS

[pratikjageera]

Hi ,

Need to apply row level security to AUDIT_VISUALANALYTICS. Can it be done.?

[RichardPaterson]

The answer is yes. This process is no different to applying security to other LASR tables. Are you familiar with this process?

RIchard

[pratikjageera]

Yes Richard , I am aware .
The one that I know involves adding as column to the TARGET table (eq ID) and then changing the lasr table authorization to (if userid eq SAS.PersonName or Identity Group).My question is how is it possible to add an extra column to such a large table (Audit_visualanalytics) which is so dynamic in nature.Creating a copy of this table and manipulating it , will not give a real time picture.. Please suggest how this can be achieved. And SAS Paper to study is also welcomed