How to limit the import set tables shown on load data screen based on the role.

[Aya Eguchi]

Hi Community

Our user is controlled by various roles, and planning to input the data by using import set, but we would like to them to choose only their related import set table from [Existing table]field, due to avoid importing the wrong data. 

Are there any ways to limit the import set table shown on [Load data] screen, when you choose the table from [Existing table]field. I addition to this,  can we set custom application menu for load data, like only shown their related import set tables by default based on their role, so user do not need to choose the import set table.

Please advice me if you have any idea to limit the import set table based on the role.

[RatneshTSN]

I tried to debug, by checking what configured in the module 'Load Data,' but no help.

If we get to know how this "create_import_set.do " configured, we can build logic there. 

I checked UI pages but can't find any. Will try to debug more and update if I find any.

[RatneshTSN]

I checked with hi-support & they told me that, create_import_set.do page isn't editable, it's implemented in XML and Java files that are part of the product and not visible or alterable by end users.

Regarding the ACLs that determine which tables will appear under 'Existing table' on this form, out-of-box the ACLs only allow users with the import_admin role to view all import set staging tables (e.g. imp_user). If you wanted to grant users access to particular import set staging tables (all of which are child tables of sys_import_set_row), you could create ACLs for each of the import set staging tables for which you want to control access.

Let me know if you need any help on ACLs

[Aya Eguchi]

Ratnesh

 Thank you for your great advice!! I appreciate for asking to hi support as well.

We came to a decision to use ACLs for particular import set tables and succeed in limit tables shown on screen!

Thanks!