# FileAccessManager - Dynamic Reviewer assignment for access certification **URL:** \ **Category:** Lifecycle & Governance\ **Created:** [June 7, 2024, 11:48am UTC](https://community.sailpoint.com/discuss/t/fileaccessmanager-dynamic-reviewer-assignment-for-access-certification/33963 "2024-06-07T11:48:39Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![sushantmundu1](https://avatars.discourse-cdn.com/v4/letter/s/958977/32.png) [@sushantmundu1](https://community.sailpoint.com/discuss/u/sushantmundu1)\ **Post date:** [June 7, 2024, 11:48am UTC](https://community.sailpoint.com/discuss/t/fileaccessmanager-dynamic-reviewer-assignment-for-access-certification/33963/1 "2024-06-07T11:48:39Z")
Hi Team, I need to assign access certification to the users who are Co-owners of the Business Resource. Username1 should be the reviewer for Business Resource 1. Username2 should be the reviewer for Business Resource 2. Example: | Business Resource | Username | PermissionType | | --- | --- | --- | | Business Resource 1 | Username1 | Co-Owner | | Business Resource 1 | Username2 | Editor | | Business Resource 2 | Username3 | Viewer | | Business Resource 2 | Username4 | Co-Owner | I’m checking FAM administrative client → Review Process but not able set the configuration. Please let me know it can be achieved. Thanks, Sushant ---
**Author:** ![ranjith\_koppu](https://sea3.discourse-cdn.com/sailpoint2/discuss/user_avatar/community.sailpoint.com/ranjith_koppu/32/17482_2.png) [@ranjith\_koppu](https://community.sailpoint.com/discuss/u/ranjith_koppu)\ **Post date:** [July 1, 2024, 7:47pm UTC](https://community.sailpoint.com/discuss/t/fileaccessmanager-dynamic-reviewer-assignment-for-access-certification/33963/2 "2024-07-01T19:47:32Z")
@sushantmundu1 Did you try the decision table option while configuring the review process in admin client ? That is specifically designed for this purpose. In your scenario, the key is the path, Object type = user, Value = the reviewer Alternatively, you can create a data source with the same data and use that in the review process as well. ![Monosnap famlab84-CORE 2024-07-01 14-45-25.png](https://cdck-file-uploads-global.s3.dualstack.us-west-2.amazonaws.com/sailpointsbx2/original/1X/4ad9effff8e0d420f5305cfefc8730c4df057d6f.png) ---
**Author:** ![sushantmundu1](https://avatars.discourse-cdn.com/v4/letter/s/958977/32.png) [@sushantmundu1](https://community.sailpoint.com/discuss/u/sushantmundu1)\ **Post date:** [July 8, 2024, 11:46am UTC](https://community.sailpoint.com/discuss/t/fileaccessmanager-dynamic-reviewer-assignment-for-access-certification/33963/3 "2024-07-08T11:46:30Z")
@ranjith_koppu I have created a new data source FAM DB with query: SELECT \* FROM [FAMDB].[whiteops].[ra\_entitlements\_user\_role\_view] where permission\_type\_name = ‘Co-owner’ and using the below data source setting in admin client, but reviews are not getting created. ![Admin Client.png](https://cdck-file-uploads-global.s3.dualstack.us-west-2.amazonaws.com/sailpointsbx2/original/2X/e/e9ec7eb3d61e3ef7020d7da6dd4003837bce27c8.png) Thanks, Sushant ---
**Author:** ![ranjith\_koppu](https://sea3.discourse-cdn.com/sailpoint2/discuss/user_avatar/community.sailpoint.com/ranjith_koppu/32/17482_2.png) [@ranjith\_koppu](https://community.sailpoint.com/discuss/u/ranjith_koppu)\ **Post date:** [July 8, 2024, 3:35pm UTC](https://community.sailpoint.com/discuss/t/fileaccessmanager-dynamic-reviewer-assignment-for-access-certification/33963/4 "2024-07-08T15:35:56Z")
Hello  @sushantmundu1 First of all, the field you highlighted in the screenshot represents a default reviewer if a reviewer is not found by FAM on a folder. This field needs to be manually filled with a user name or a group name. Select the appropriate value in the drop down. The second part is the configuration of the data source. As you are planning to use a data source query, your query should rows with 4 columns. 1. Folder name (Map it to the key column) 2. User Domain Name/Group Domain name (Map it to Object Domain Column) 3. User Name/Group Name (Object Name Column) 4. A constant value something like “User” or “Group” for the Object Type Column. When FAM needs to find the approver for a particular folder, it checks this data source. If the folder path is found, it picks the group/user name from the mapping. If something is not found, it defaults to the default value. Hope that helps. Cheers, Ranjith ---
**Author:** ![sushantmundu1](https://avatars.discourse-cdn.com/v4/letter/s/958977/32.png) [@sushantmundu1](https://community.sailpoint.com/discuss/u/sushantmundu1)\ **Post date:** [October 9, 2024, 2:42pm UTC](https://community.sailpoint.com/discuss/t/fileaccessmanager-dynamic-reviewer-assignment-for-access-certification/33963/5 "2024-10-09T14:42:20Z")
Hi Ranjith, In data source I’m using query: SELECT [user\_name],[user\_domain],[user\_entity\_type\_name],[permission\_type\_name]FROM [FAMDB].[whiteops].[ra\_entitlements\_users\_view] where [permission\_type\_name]=‘Co-owner’ and kept attached setting in admin client, but still review is going to default user. Problem Statement: Reviewer should be co-owner of the BOX folder. Please let us know how to configure this. Thanks, Sushant ![Screenshot 2024-10-09 200513.png](https://cdck-file-uploads-global.s3.dualstack.us-west-2.amazonaws.com/sailpointsbx2/original/2X/5/5e97154709f7205262583b19c840a55f04bd7415.png)