Imagine you have to provide a list of tables (I mean, an editable one…that you can copy paste…) used by a dataprovider’s owner.

If you can get connected to your SAP BODI repository you could use this request:

select distinct descen_obj from AL_PARENT_CHILD
where descen_obj_owner = 'the DP s Owner'
order by 1

The thing is that it is difficult to get it from the BODI Designer itself as an editable list. This might come usefull to a DBA in case, for example, that he must give some grants to a list of tables for another environment.