Question:
Hi
doe anyone know what tables are used to store the connection between query(workbook) and InfoProvider in BW?
We want to create a DB that we can use to list thes and control thet access to Infoproviders from there. but i can not find the right table?
Answer:
Never thought about it but its quite likely that it isn't stored in any table per se but is part of the generated query definition. Why do you need a table to control access? The delivered authorization objects control this just fine.
_________________
bwSecurity
Answer:
our design is based on:
for every business area
1 report Menu role
1 report reader role
1 report writer role
1 report publisher role.
However we also have report builders with wider access and we are not always informed whne they creat new queries on Infoproviders (not yet) in the normal roles we want to be able by simple tanbel download to see if there are inforpoviders needed for teh reports that are not in the Reader or Writer roles. I was able to find a lot of info to make this happen, but can not find the table that links the Technical name of a query/workbook to the infoprovider.
Answer:
Long ago I wrote a report that determined all the variables used in queries. The tables I went through may have had infoprovider data. I will look for it. In the meantime you may want to look in your statistics cubes if they are turned on. They will only report queries that have been executed over a period of time but you can see the query/infoprovider relationship.
_________________
bwSecurity
Answer:
Hi,
you can use either one of the following views to find the relationship between InfoProvider and queries :
V_REP_JOIN
V_COMPDIR_COMPIC
Regards,
Fairis