how to fetch login details in report designer

Rohit26 — Thu, 17 Aug 2017 05:44:38 GMT

Hi,

I have created a list table of all users of SAS VA using report designer.

I just want user name must be highlighted whenever the specific person is logged in into SAS VA HUB.

Is there any possible way to do it?

Thanks

Re: how to fetch login details in report designer

BrunoMueller — Fri, 18 Aug 2017 08:20:24 GMT

As you mentioned you already have a table with all the relevant information for all the users.

You can use the Row Level Security functionality to just show the information for the user logged in.

For this to work you need to set a conditional GRANT on the table in question.

There are various ways of doing this, for instance using the CLI tool sas-set-metadata-access, here is an example:

sas-set-metadata-access -profile SASAdmin "/Shared Data/SAS Visual Analytics/Public/LASR/USERINFO_TEST(Table)" -grant sasusers:Read -condition "userId contains 'SUB::SAS.Userid'"

Another way is using the SAS Visual Analytics Adminstrator, aseen here

https://communities.sas.com/t5/SAS-Visual-Analytics/SAS-Visual-Analytics-7-3-Row-Level-Security/m-p/325739#M6164

You will find more information on how to use Row Level Security in this paper:

http://support.sas.com/resources/papers/proceedings16/SAS6660-2016.pdf

topic how to fetch login details in report designer in SAS Visual Analytics

how to fetch login details in report designer

Re: how to fetch login details in report designer