on Sep 10, 2019Hi Team,
Is there a way to select the reviewers from custom query in User Access Review.
We have a requirement to allow users to review their own access. Can we reference to dynamic values from context in coverage file.
Please help.
Thanks,
Jaydeep Mehta
There are two different things you asked about here:
Yes that is possible using coverage files. What I've seen in many places is using a the custom query to create the coverage file. So for example, assuming that your custom query to get the reviewer vs the user is:
select REVIEWER_USER_ID, USER_ID from MY_CUSTOM_REVIEWERS_TABLE
Then you can create another query using this that would output the structure of your coverage CSV file:
select 'user_id=' || REVIEWER_USER_ID || '|user|user_id=' || USER_ID || '|application|1=1|' as coverage_file from MY_CUSTOM_REVIEWERS_TABLE
The output of the above query, if exported as a CSV file without headers, can be directly used as a coverage file. You can of course change the structure of the query as you wish.